Software

Ask something
Question Locked

restoring sql 2000 using mdf and ldf files

0 helpful
9 replies

by mkazembe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

SQL 2000 database was uninstalled unintentionally,all records hav been lost,no backup
.How do i restore the database using mdf and ldf files.

9 replies

by shellbot

Reinstall SQL ( :) )

-Click Databases -> all tasks -> attach
-Choose your mdf file
-give it a name , choose owner and OK it.

Next step..check it to make sure its ok..then back it up..and set up a regular back up plan...

And seriously..if this is not for personal use someone needs to pull thier finger out...who's going around uninstalling this kind of stuff??? I'd be fired if i did that...

by mkazembe

thanks 4 the idea, i managed to get around the problem by reinstalling sql and excuting a string a sql commands. it was really tidoius.

by mkazembe

thanks 4 the idea, i managed to get around the problem by reinstalling sql and excuting a string a sql commands. it was really tidoius.
A consultant trying to instal their water prepaid system, messed up the other system.

by tony hopkinson

Depnds on what databases you want to recover, if it includes master, there are ways. If it's just a 'user' database then you need to look up attach.

Note if you've had to reinstall sql server your logins and users will be disconnected as well.

by shellbot

didn't think to ask what he wanted to restore..looks like's gone anyways..

glad i'm not the one who has to take care of that potential mess :)

by tony hopkinson

Never figured out why you'd want to do it more than once either. :D

So we've no back up, production is stopped, the data is highly critical.

No pressure.....

FFS :p

by mkazembe

thanks 4 the idea, i managed to get around the problem by reinstalling sql and excuting a string a sql commands. it was really tidoius.
A consultant trying to instal their water prepaid system, messed up the other system

by tony hopkinson

There's always some wrinkle in the this is how to do it procedure.

PS.

Back it up !!!!

This discussion is closed to new replies.