0

We have a Windows Server 2008 which is offline. We no longer have access to the server OS, or any GUI tools, but we do have a backup of the entire C:/ of this server.

This server used to host an SQL server instance, and we now need to access of one of the databases on this server, so that we can move it to a new server.

How can we achieve this?

Can we simply copy the MSSQL/DATA directory from the backup file to a new server?

asked Jan 13, 2022 at 15:15
1

1 Answer 1

5

If you can find .mdf and .ldf file you can try to attach it to the new SQL instance using below:

CREATE DATABASE <db_name>
 ON (FILENAME = '<mdf file path>'), 
 (FILENAME = '<ldf file path>') 
 FOR ATTACH;

Also you can check this solution:

https://stackoverflow.com/questions/61954107/how-to-attach-a-database-by-mdf-file-that-has-not-been-detached

answered Jan 13, 2022 at 16:24

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.