SEO

#1 (**permalink**) 02-29-2008, 08:09 PM

Hello,

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?

regards
Mark

#2 (**permalink**) 02-29-2008, 08:09 PM

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

#3 (**permalink**) 02-29-2008, 08:10 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

copy database via tapefile no SQL 2005