0

We had a SQL server die due to some RAID problems. We sent the machine out to a data recovery company and they are able to recover the .MDF and .LDF files from the drives. Will I be able to use those files to restore the databases to a new machine? What do I need to watch out for? Thanks!

asked Jul 14, 2016 at 14:11
2
  • 1
    With the MDF (main data file) and LDF (log data file), you may be able to attach the database to a new server: see the MSDN manual page for a lot of info that you should read. Commented Jul 14, 2016 at 14:17
  • after attach, take a backup at every step... and then define a backup strategy because raid is not a backup... Commented Jul 14, 2016 at 15:27

2 Answers 2

0

Have u tried out the old way of creating empty database with same name. Stop sql server
Paste database at the same location ...
And restart the server ....
Does it helping u out .....
May be this article will give you more information.
http://www.techrepublic.com/forums/questions/it-seems-our-sql-database-is-corrupted/

answered Jul 20, 2016 at 16:29
0

unless they are not corrupted,You can use the files to restore databases.With out restoring you cant say about usability of those files..

If you are able to restore them with out any issues

1.First take backup of what you restored
2.Do a DBCC CHECKDB to check for any signs of data corruption

answered Jul 14, 2016 at 14:14
1
  • Thank you all for your advice! The issue has been resolved. Commented Jul 21, 2016 at 22:01

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.