Restoring Backups | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restoring Backups

Here is the problem,
There is a database on my live server that I desperately
need to view the backup of. But I can’t restore it because it will overwrite data that can’t be overwrittin. I have
downloaded the backup to my local server. But the problem
is how can I view this backup on my local machine. Is
there a way to view backed up DB’s without restoring them? Please help.
Just restore it on your local machine. Is there any reason why you cannot? Bambola.
No as referred by bambola, use RESTORE statement to another (clone) database to see the data. _________
Satya SKJ

Just use a different name while restoring it and it will create a new database with that name, without overwriting on the exisitng one.