Install db from backup

[hamking01]

I received a backup of a db with .bak extenstion. I'm trying to restore it on my local computer. Could anyone tell me the steps of setting this up.

I've tried from query analyzer's master run the following command:

restore database bt
from disk = 'c:\BolTrab_28.10.2005.bak'

But this returns:
Cannot open backup device 'c:\BolTrab_28.10.2005.bak'. Device error or device off-line.

 

[mrdenny]

Do you have the SQL Server installed on your local workstation? You have to restore the database to the server that you are connecting to.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

Also, where is that backup file located at? Did you copy it to your local C drive?

-SQLBill

Posting advice: FAQ481-4875

 

[hamking01]

Yes I have sql server installed on my local computer. I was emailed the bak file and moved the file to my C drive. I then ran the above command.