restore database to temp area

[colinbell]

Hi

I have my live Database CCCInternet which has a backup performed this morning

I don't want to touch the live Database (because of work done this morning) but I'd like to restore CCCInternet.bak to a temporary Database (I don't want to overwrite anything that is live) and compare one particular table to the live Database

thanks
ian

 

[tran008]

Not sure what you mean by 'temporary' but the easiest way is to use EM to restore the back up database on to a new database. Or use the following in the QA:

USE master
GO
RESTORE DATABASE NewDatabaseName
FROM TAPE = 'Backuptape'
GO

 

[SQLBill]

I would use your install disk and install a new instance of SQL Server. Then restore the database to that instance. Then do the compare.

If you restore it to the same instance, you will have two databases with the same name and SQL Server will not know which one to use. To restore to the same instance requires changing the name of the database/files. If you have to do it this way, I suggest detaching the original database then restoring the old one. Change the name of the old one and then reattach the original/current one.

-SQLBill