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?

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.