how to restore a database .bak files

Oct 11 2010 2:10 AM
hi,
i have one .bak file i am trying to restore data base i get the following error what is the problem in my process i copy that .bak file from d drive to c drive also it is show the same error . in my system i have only c and e drives but it is display error with the d drive what is the problem here

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'SPARSH151\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Directory lookup for the file "D:\Personal\Personal1\Documents\KhamtekInfo\Projects\BSNL\DBBackUp\BSNLAP.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Answers (2)