Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pankajkkarn
Starting Member
1 Post |
 Posted - 2009-01-24 : 03:30:20
|
| i have a backup file BackupFile.Bak from FaData1501, but i want to restore dadabase FaData1502 (old name FaData1501). command is given below:*****************RESTORE DATABASE FaData1502 FROM DISK = 'D:\acx\BackupFile.Bak' WITH MOVE 'FaData1502_data' TO 'D:\acx\FaData1502.mdf' , MOVE 'FaData1502_Log' TO 'D:\acx\FaData1502_log.ldf'*****************but i am getting error message-Server: Msg 3234, Level 16, State 2, Line 1Logical file 'FaDataDIA1502' is not part of database 'FaData1501'. Use RESTORE FILELISTONLY to list the logical file names.Plz help me |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-24 : 03:41:03
|
| What does RESTORE with the FILELISTONLY option return?--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Restore