Monday, March 26, 2012

restore database to new database

This is the 1st time I have had to restore to an alternate location.
I followed the threads from other posts (and BOL) but am having no luck.
I have a prod database called DATA. I need to restore an older backup to
retrieve info BUT to another database data_tl (it is not created).
In QA, I ran this against Master but...
RESTORE FILELISTONLY
FROM DISK = 'F:\Microsoft SQL Server\MSSQL\backup\data011504.bak'
RESTORE DATABASE data_t1
FROM DISK = 'F:\Microsoft SQL Server\MSSQL\backup\data011504.bak'
WITH MOVE 'data_t1_Data' To 'F:\Microsoft SQL
Server\MSSQL\data\data_1_data.mdf',
MOVE 'data_t1_Log' To 'F:\Microsoft SQL Server\MSSQL\data\data_1_log.ldf'
with the following error msg.
(2 row(s) affected)
Server: Msg 3234, Level 16, State 2, Line 3
Logical file 'data_t1_Data' is not part of database 'data_t1'. Use RESTORE
FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.
Obviously I am missing something in my syntax but can't see it for the life
of me.
TIA,
Susan Simpsonwhat returned when you run this line:
RESTORE FILELISTONLY FROM DISK = 'F:\Microsoft SQL
Server\MSSQL\backup\data011504.bak'
?
"Susan Simpson" <ssimpson@.infospectruminc.com> wrote in message
news:ujGtgva8DHA.2560@.TK2MSFTNGP09.phx.gbl...
> This is the 1st time I have had to restore to an alternate location.
> I followed the threads from other posts (and BOL) but am having no luck.
> I have a prod database called DATA. I need to restore an older backup to
> retrieve info BUT to another database data_tl (it is not created).
> In QA, I ran this against Master but...
> RESTORE FILELISTONLY
> FROM DISK = 'F:\Microsoft SQL Server\MSSQL\backup\data011504.bak'
> RESTORE DATABASE data_t1
> FROM DISK = 'F:\Microsoft SQL Server\MSSQL\backup\data011504.bak'
> WITH MOVE 'data_t1_Data' To 'F:\Microsoft SQL
> Server\MSSQL\data\data_1_data.mdf',
> MOVE 'data_t1_Log' To 'F:\Microsoft SQL
Server\MSSQL\data\data_1_log.ldf'
> with the following error msg.
> (2 row(s) affected)
> Server: Msg 3234, Level 16, State 2, Line 3
> Logical file 'data_t1_Data' is not part of database 'data_t1'. Use RESTORE
> FILELISTONLY to list the logical file names.
> Server: Msg 3013, Level 16, State 1, Line 3
> RESTORE DATABASE is terminating abnormally.
> Obviously I am missing something in my syntax but can't see it for the
life
> of me.
> TIA,
> Susan Simpson
>
>

No comments:

Post a Comment