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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-06-15 : 16:44:20
|
| im rstoring a db the file is 7gig. Its taking more than 10 minuts..how do i know if the backup file is ok to restore it=============================http://www.sqlserverstudy.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-15 : 16:46:52
|
| There's no way to know if a backup file is restoreable until you actually restore it.Run the restore command using the with stats option so you can see its progress.restore database db1from disk = 'E:\db1.BAK'with statsTara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-15 : 16:49:16
|
| Can use 'restore verifyonly' to check if the backup is good. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-15 : 16:53:47
|
quote:
Originally posted by rmiao
Can use 'restore verifyonly' to check if the backup is good.
That doesn't verify that it is restoreable. The only way to know if it is restoreable is to actually perform a restore. This is why it is so important to test out your production backups on another server. You could be in a position with no valid backups even though you've been backing up your database daily.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
restore taking very long