restoring database help - SQL Server Forums

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 Programming

restoring database help

Author

Topic

stryke
Starting Member

5 Posts

Posted - 2006-02-26 : 12:50:49

theres two .mdf files
game_log.mdf
game_data.mdf
is there a way to restore a database with these files but not with .bak (backup) files?

i couldn't connect to database so i reinstalled sql server 2000 and this time i could connect to the sql server fine but when i tried to restore the database, it wouldn't work when i set it to transcation log and it shows an error

The preceding restore operation did not specify WITH RECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step. RESTORE LOG is terminating abnormally.

please help, thank you

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-26 : 13:17:06

do you have the .LDF file also?

Are these 2 separate databases, or are they 2 datafiles for one database?

-ec

stryke
Starting Member

5 Posts

Posted - 2006-02-26 : 13:31:45

whats a .ldf file ?

yes they are 2 datafiles for one database
and will this help me?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37161&whichpage=2

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-26 : 13:38:22

quote:
Originally posted by stryke

whats a .ldf file ?
yes they are 2 datafiles for one database
and will this help me?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37161&whichpage=2

the .LDF file is the transaction log file.

yes, that thread you linked to is pertinent. Make sure that when you attempt to attach these datafiles that you use a copy. Do not try anything with the original files.

-ec

stryke
Starting Member

5 Posts

Posted - 2006-02-26 : 13:45:08

oh so what is game_log.mdf file?
its like 60 gb

and that topic is confusing im new to this sql server thing
like when i tried to detach my database it said its in use do you have msn? so you can help me faster

thanks for quick replies

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-26 : 13:48:35

quote:
Originally posted by stryke

oh so what is game_log.mdf file?
its like 60 gb

I don't know, it is your database

maybe the file is misnamed and is really a .LDF, but usually a .MDF file is a datafile not a logfile.

make copies of these files and then attempt to use the sp_attach_db command.

-ec

stryke
Starting Member

5 Posts

Posted - 2006-02-26 : 13:53:07

i didn't make it though i got it from a tutorial :P

u have msn? so if i have trouble i will get quick responds
if i make a a copy of the file it will take up 120 gb?

stryke
Starting Member

5 Posts

Posted - 2006-02-26 : 19:38:20

please help.
i dont understand 9. and 10.?
how can i do it if i dont have the old databse..
someone plz helppp :(
my database MuOnline is a suspect cant select properties

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources