Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PingTheServer
Starting Member
28 Posts |
 Posted - 2008-12-08 : 15:01:47
|
| We are going to have a new SQL server soon and in coming up with a backup strategy, a co-worker suggested detaching and imaging at night, since our transactions only occur during regular business hours.We will not have imaging software available, but I will have Backup Exec and BE System Recovery available. Would you Reboot or detach before backing up? Also...some of our tables have a couple dozen files/filegroups.Just curious how some of you do it, as I am new to SQL. Thanks |
|
|
crosan
Starting Member
13 Posts |
Posted - 2008-12-08 : 15:09:43
|
| SQL Server essentially does a hot backup by default which does not require the database to be down for the duration. I'd suggest just doing a SQL Server backup then having your backup software just pick up the backup files after they are finished. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-12-08 : 15:11:07
|
| I never reboot or detach before a backup. It is pointless to do a hot backup if you are going to take the database offline. I support about a hundred servers and hundreds of database, most are mission critical and have high availability requirements. We would get into a lot of trouble if we did what your co-worker has suggested. Does your co-worker have SQL Server and/or DBA experience? I'm guessing no based upon the suggestion.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
PingTheServer
Starting Member
28 Posts |
Posted - 2008-12-08 : 16:34:15
|
| He's been a programmer and dba for about 10 years. Mostly Oracle.Crosan, I like your idea. I will most likely send the .bak file made natively in SQL to tape (daily to a disk), and just keep the tapes rotating.I guess I need to figure out how this Backup Exec System Recovery (baremetal) works to see how I can get SQL 05 and the OS back online the quickest. My hunch is that it works something like imaging...so what I may do is do a weekly shot for the baremetal restore, and send the other .bak files to tape and disk. Then in an emergency, do a baremetal restore and then the most recent .bak + logs.I'm trying to think this all the way through so I can practice,prove, and document the successfulness of the backup strategy so other people can follow it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Do you detach before backup?