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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Unable tro restore database

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's

i am the only user logged in as SA through management studio


i have tried restore filelist and i got
RESTORE 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 1
Sports_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 1

after seeing this i tried
RESTORE DATABASE Sports
FROM 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 error

Msg 3234, Level 16, State 2, Line 1
Logical file 'sports' is not part of database 'Sports'. Use RESTORE FILELISTONLY to list the logical file names.
Msg 3013, Level 16, State 1, Line 1
RESTORE 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




----------
BR
IA

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 Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -