SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server backups
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tfountain
Constraint Violating Yak Guru

USA
491 Posts

Posted - 11/14/2012 :  10:05:47  Show Profile  Reply with Quote
This is more of a poll but I'd like to get others opinions. What is the recommend and preferred methods of SQL Server backups considering all technologies:
- Native SQL Server backup to tape
- Native SQL Server backup to disk
- SAN backups (specifically for my purposes - NetApp Snapshots / FlexClones).

Go!

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1754 Posts

Posted - 11/14/2012 :  14:45:33  Show Profile  Reply with Quote
We backup to a network drive (with compression). From there the backup file is saved to tape for long term retention and the backup drive is saved for intermediate term availability.

=================================================
We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
Go to Top of Page

donpolix
Yak Posting Veteran

97 Posts

Posted - 11/14/2012 :  15:43:53  Show Profile  Click to see donpolix's MSN Messenger address  Send donpolix a Yahoo! Message  Reply with Quote
Native sql backup with compression to SAN drive. Backup files are then backed up to tape by Netbackup.

Donn Policarpio
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 11/14/2012 :  16:18:18  Show Profile  Visit robvolk's Homepage  Reply with Quote
Backing up directly to tape is deprecated in T-SQL. I don't believe it's recommended by Microsoft, and no DBA I know of recommends it.

We back up to a local drive and use 3rd party compression to save additional space, and then copy over to a network share. We are currently adding offsite backup as a "tape" option, but all our on-site backups are kept on network shares.
Go to Top of Page

tfountain
Constraint Violating Yak Guru

USA
491 Posts

Posted - 11/15/2012 :  10:52:35  Show Profile  Reply with Quote
Interesting that the tape option is depreciated. Any thoughts on how that will impact the tape vendors, say like Backup Exec?
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 11/15/2012 :  11:08:09  Show Profile  Visit robvolk's Homepage  Reply with Quote
I'm not too thrilled with many backup vendors anyway, the market can stand to lose a few. Don't blame Microsoft for tape's demise, everyone's moving to flash storage too. Disk is the new tape.
Go to Top of Page

tfountain
Constraint Violating Yak Guru

USA
491 Posts

Posted - 11/19/2012 :  13:48:24  Show Profile  Reply with Quote
Thanks for your input everyone. You've helped me confirm my initial direction is valid - backup to disk and then allow our infrastructure group backup the files to tape.

Currently our databases are backuped up to tape directly and there are all sorts of issues. It currently takes 9+ hours to do a full backup of all our databases (just under 1 TB). And that's only production. My new proposal is going to go straight to disk plus include a few additional optimizations (to name a few):
- Use compression where necessary
- Use multiple backup files (up to 1 per CPU)
- Separate backup traffic from the network traffic

I see no reason why we cannot backup 1 TB of data to disk in 30 minutes tbh. I based most of this on a case study for fast and reliable backup and restore of VLDB over the network.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000