I use the folwing syntax to restore
and get an error. Any idea why?
RESTORE DATABASE ADDSDemo
FROM DISK = '\\cdcsqlnode02\e$\Backup\node2\ADDSDemo.bak'
WITH STANDBY= 'E:\MSSQL\Data\undoADDSDemo_log.ldf',
MOVE 'ADDSDemo' TO 'D:\MSSQL\Data\ADDSDemo.mdf',
MOVE 'ADDSDemo_log' TO 'E:\MSSQL\Data\ADDSDemo_log.ldf'
ERROR
Server: Msg 3234, Level 16, State 2, Line 1
Logical file 'ADDSDemo' is not part of database 'ADDSDemo'. Use RESTORE FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Dr.Sql
Good Luck.
and get an error. Any idea why?
RESTORE DATABASE ADDSDemo
FROM DISK = '\\cdcsqlnode02\e$\Backup\node2\ADDSDemo.bak'
WITH STANDBY= 'E:\MSSQL\Data\undoADDSDemo_log.ldf',
MOVE 'ADDSDemo' TO 'D:\MSSQL\Data\ADDSDemo.mdf',
MOVE 'ADDSDemo_log' TO 'E:\MSSQL\Data\ADDSDemo_log.ldf'
ERROR
Server: Msg 3234, Level 16, State 2, Line 1
Logical file 'ADDSDemo' is not part of database 'ADDSDemo'. Use RESTORE FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Dr.Sql
Good Luck.