Trouble restoring database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Trouble restoring database

Author

Topic

CoffeeAddict
Yak Posting Veteran

94 Posts

Posted - 2009-09-17 : 20:52:49

I am taking a .bak and trying to restore it. In options I specify a folder path for the following (see here):

http://www.elbalazo.net/post/restore.jpg

When I try to restore, I get this message:

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

Restore failed for Server 'DEVVM'. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

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

System.Data.SqlClient.SqlError: Directory lookup for the file "E:\MMSQL\DATA\Pmall.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&LinkId=20476

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

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

I mean why? I just restored another database and it was fine. I deleted the database that was there and I'm restoring the same one, just newer .bak. There are not files in that Data folder yet, it should create one for me. So if it creates them why is it saying they are not there!

I know if in options I point the restore to the default directory instead (E:\MMSQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\xxx.mdf) it works but I don't want that. Last time we were able to restore to the location you see in the picture.

CoffeeAddict
Yak Posting Veteran

94 Posts

Posted - 2009-09-17 : 21:07:33

How fing weird. When I browse to the folder instead of retyping it in, it works. So I have to browse? wtf.

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2009-09-18 : 13:30:35

it is better to browse then type, anyhow your problem solved.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources