Posted by Mark on 08/16/06 19:26

Hello Erland,
good tip, thank you very much !
I haven´t seen it :-/
regards Mark


"Erland Sommarskog" <esquel@sommarskog.se> schrieb im Newsbeitrag
news:Xns98203142E059Yazorman@127.0.0.1...
> Mark (Scollop027@gmx.net) writes:
> > if you got a tape file how can you restore the contained database onto a
> > newly installed server? I choose Restore Database From Device then I
> > choose DB and select same DB in combobox "To Database" but error
> > occured:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > Restore failed for Server '...'. (Microsoft.SqlServer.Smo)
> > ADDITIONAL INFORMATION:
> > System.Data.SqlClient.SqlError: Directory lookup for the file
"C:\Program
> > Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf" failed
with
> > the operating system error 3(error not found). (Microsoft.SqlServer.Smo)
> >
> > what can I do to handle this problem?
>
> First do
>
> RESTORE FILELISTONLY FROM TAPE = 'tapedevice'
>
> this will give you the logical names of the files of the database. Then
> do:
>
> RESTORE DATABASE db FROM TAPE = 'tapedevice' WITH
> MOVE 'datafile' TO
> C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\KidDatabase.mdf',
> MOVE 'logfile' TO
> C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\KidDatabase.ldf',
> REPLACE
>
> Here I've used the path from your error message. Howver, the error message
> indicates that this is a non-existing path, so you may have to examine
> where there is place on the server to put the databases.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]