Point in time Recovery

[19771947]

I have a SQLServer 2005 database. I want to restore from the backup to 2 days back point in time. I am using the Microsoft SQLServer Managment Studio. After I pick the file and specify the time I keep getting the error:


System.Data.SqlClient.SqlError: RESTORE cannot process database 'DBNAME' because it is in use by this session. It is recommended that the master database be used when performing this operation. (Microsoft.SqlServer.Smo

I did a server reboot to clear off any hanging session.Stil I am getting the message. Please suggest.

Thanks

 

[TheSQL]

Force the server to point to a different database. Open up a new query, and type:

USE master 
RESTORE DATABASE DBName FROM DISK = 'c:\MyDBBackup.bak'

Where DBName is your database and C:\MyDBBackup.bak is the file you're restoring.