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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx