Question

Locked

restoring sql 2000 using mdf and ldf files

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

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Quick & Dirty

by Shellbot In reply to restoring sql 2000 using ...

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...

Collapse -

thanks

by mkazembe In reply to Quick & Dirty

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.

Collapse -

thanks

by mkazembe In reply to Quick & Dirty

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.

Collapse -

That could be fun

by Tony Hopkinson In reply to restoring sql 2000 using ...

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.

Collapse -

ah

by Shellbot In reply to That could be fun

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 :)

Collapse -

Never seen this done twice the same way

by Tony Hopkinson In reply to ah

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

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

No pressure.....

FFS

Collapse -

managed

by mkazembe In reply to That could be fun

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

Collapse -

I've done it maybe three times now over various versions

by Tony Hopkinson In reply to managed

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

PS.

Back it up !!!!

Back to Software Forum
8 total posts (Page 1 of 1)  

Related Forums