iamsam.sandeep (12/29/2010)
Thanks 2 all the the Responce.I was right i had mentioned 'xp_restore_verifyonly' , when i replied that you can test it in ur test env he strangely told me that u do not have any other option you have to restore directly in production.
No, I don't agree. You can restore that to another system and validate it's what you want before you restore it to production. Or, if forced, you restore it to a new database on production, validate and then restore over the existing database. You have a number of options that you can use before you get to just flat out overwriting the existing prod system with your fingers crossed.
BTW, if it was a native backup, not LiteSpeed as it seems to be, you could look at using Red Gate Virtual Restore[/url] to create a database off the backup without actually restoring it. Cool stuff.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning