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 |
|
shiyam198
Yak Posting Veteran
94 Posts |
 Posted - 2011-09-14 : 12:01:43
|
| Hi,I am going to take a backup of the Production system and upgrade it to the new version of the application.The backup and restore takes about 8 hours. I am trying to cut down sometime. Will taking a snapshot and restore (attach) be safe? will it be faster?I am reading through manuals. but I would like a practical opinion.Thanks a lot in advance.Regards,Shiyam |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-14 : 12:11:24
|
| You can't use a snapshot for this.Have a look at this article regarding snapshots.http://msdn.microsoft.com/en-us/library/ms189940.aspx |
 |
|
|
shiyam198
Yak Posting Veteran
94 Posts |
Posted - 2011-09-14 : 12:30:33
|
| Thanks a lot Russ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-14 : 14:00:43
|
| We take a Full Backup at a convenient time "shortly" before an upgrade, and then a differential backup after we have entered scheduled downtime.If the DIFF is still too slow you could do a TLog backup, then Diff, immediately before scheduled downtime and then a TLog backup after downtime starts - so at worst you would have to recover Full, Diff and one TLog backup.That would still leave you an 8 hour restore though ... if you have to restore.Would stop-the-SQL-service and copy-the-physical-files be quick enough? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-14 : 14:49:37
|
| How big is that DB? I had a 1TB database on very slow drives that only took 5 hours to back up. If you're using SQL 2008 Enterprise, look at compressed backups. If you're not, look at a 3rd party tool that compresses backups.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Snapshots VS Backup and restore