×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Hello I am new to a new organizatio

Hello I am new to a new organizatio

Hello I am new to a new organizatio

(OP)
Hello I am new to a new organization - Las Vegas Casino as a SQL Server DBA to the organization.
The databases are small as the organization is relatively small compared to others around here.
Based on the fact that there is a lot of OLTP online transaction processing occurring everyday. Sorry, I am from the Oracle world.
I will like anyone to recommend a backup strategy for me.
They are currently using VEEAM (The software provides backup, restore and replication functionality for virtual machines, physical servers and workstations as well as cloud-based workload)for granular backup to disk level for ALL systems including NETWORK, MIDDLE-WARE and DATABASE.
I will like to propose the following:
1) Continue to use VEEAM, to prevent a single point of failure during recovery, in addition I will like them to do a weekly full backup in Full recovery Mode. Then do daily incremental backups for some databases and the rest of busy database can have transactional log backups every 5 mins.
2) In addition to above, we can use local backup up to disc with the same strategy, weekly full backup in Full recovery Mode. Then do daily incremental backups for some databases and the rest of busy database can have transactional log backups every 5 mints. The only different from 1) is that backups will appear in local disk alone.
3) Tripple sure the recovery by creating a free account in Azure Cloud, and propagate/shipped 2) into the Cloud once the 2) is finished every night. Remember, I tell you the databases are relatively small, but growing exponentially.

Please let me know:
If the strategy of a weekly full backup in Full recovery Mode. Then do daily incremental backups for some databases and the rest of busy database can have transactional log backups every 5 mints. The only different from 1) is that backups will appear in local disk alone.

Also, can one also shipped the backups sets to Azure Cloud?

Thanks in-advance for your help.

Tekpr00


RE: Hello I am new to a new organizatio

First recommendation would be to do disk mirroring (RAID) so that there is a second copy of the data for failover (and backup). The RAID disk could be in the cloud.

Another possibility is getting a second server and doing replication at the database level. Again, the second server could be in the cloud.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close