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 |
irfanalavi
Starting Member
1 Post |
Posted - 2011-01-12 : 05:58:19
|
i am using sql server express 2005 along with its management studio,i wish to recover a db from a .bak file from another server,the machine i am currently on is also running ms sql express 2005 with management studio and has zero users who can connect to the sql db'si am the only user logged in as SA through management studioi have tried restore filelist and i gotRESTORE FILELISTONLY FROM DISK = 'D:\dbo.sports.bak' Sports_Data G:\General\Common\PNS_LnTDhanush\sports.mdf D PRIMARY 11206656 35184372080640 1 0 0 00000000-0000-0000-0000-000000000000 0 0 9764864 512 1 NULL 362000000234900036 CC9C43FA-D90D-43B4-B316-61A9E5029A62 0 1Sports_Log G:\General\Common\PNS_LnTDhanush\Sports_log.ldf L NULL 204079104 35184372080640 2 0 0 00000000-0000-0000-0000-000000000000 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 1after seeing this i tried RESTORE DATABASE SportsFROM DISK = 'D:\DBO.SPORTS.BAK'WITH REPLACE, MOVE 'sports' TO 'D:\irfan\sports.MDF',MOVE 'storeshop_log' TO 'D:\irfan\sports_Log.LDF'and i got errorMsg 3234, Level 16, State 2, Line 1Logical file 'sports' is not part of database 'Sports'. Use RESTORE FILELISTONLY to list the logical file names.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.this is an old database and somehow the .mdf file is deleted from even the actual server, so i need to retore, first i will restore on this local machine & then on server.somebody please help----------BRIA |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-12 : 06:06:18
|
According to the output of restore filelistonly, the logical names of the data and log file are not 'sports' and 'storeshop_log', which you used in the restore, but 'Sports_Data' and 'Sports_Log'Change your restore to use the correct logical names of the data and log file--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
|