copy database via tapefile no SQL 2005

[Mark]

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.SqlS erver.Smo)
ADDITIONAL INFORMATION:
System.Data.Sql Client.SqlError : Directory lookup for the file "C:\Program
Files\Microsoft SQL Server\MSSQL.1\ MSSQL\DATA\KidD atabase.mdf" failed with
the operating system error 3(error not found). (Microsoft.SqlS erver.Smo)

what can I do to handle this problem?

regards
Mark

[Erland Sommarskog]

Re: copy database via tapefile no SQL 2005

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.SqlS erver.Smo)
ADDITIONAL INFORMATION:
System.Data.Sql Client.SqlError : Directory lookup for the file "C:\Program
Files\Microsoft SQL Server\MSSQL.1\ MSSQL\DATA\KidD atabase.mdf" failed with
the operating system error 3(error not found). (Microsoft.SqlS erver.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\KidD atabase.mdf',
MOVE 'logfile' TO
C:\Program Files\Microsoft SQL Server\MSSQL.1\ MSSQL\DATA\KidD atabase.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@sommarsk og.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

[Mark]

Re: copy database via tapefile no SQL 2005

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


"Erland Sommarskog" <esquel@sommars kog.seschrieb im Newsbeitrag
news:Xns9820314 2E059Yazorman@1 27.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.SqlS erver.Smo)
ADDITIONAL INFORMATION:
System.Data.Sql Client.SqlError : Directory lookup for the file

"C:\Program

Files\Microsoft SQL Server\MSSQL.1\ MSSQL\DATA\KidD atabase.mdf" failed

with

the operating system error 3(error not found). (Microsoft.SqlS erver.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\KidD atabase.mdf',

MOVE 'logfile' TO
C:\Program Files\Microsoft SQL

Server\MSSQL.1\ MSSQL\DATA\KidD atabase.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@sommarsk og.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/prodinf...ons/books.mspx