-
SQL Database Recovery
I just had to reload my windows 2000 server because of corrupt files. I was able to ghost my data across to another disk. Unfortunately, i lost my database backup files but still have the .mdf and .ldf files. Is there any way of restoring these databases using these files?
-
sp_attach_db
and
sp_attach_single_file_db
refer bol for the above these two commands
-
unless you need the ldf file you can just attach the mdf and a new minimum size ldf will be auto created for you.
A good if unorthodox way of clearing out a massive log file as well. Make sure you don't need anything that may be in it though.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|