Can I recover a damaged SQL Server 2008 database Topic is solved

Using PhotoRec to recover lost data
Locked
Message
Author
estaf37
Posts: 1
Joined: 28 Nov 2014, 16:05

Can I recover a damaged SQL Server 2008 database

#1 Post by estaf37 » 28 Nov 2014, 16:33

Their original SQL Server was 2008, with SP unknown, but installed on D: and C: drives. The power spike corrupted their O/S on the C: drive and someone reinstalled both the O/S and the SQL Server, which is now SQL 2008, SP4. They have intact files for all system databases, both .mdb and .ldf. Is there some way they can reconnect with the user databases using the intact copies of the previous system databases?

I have heard that if the SQL Server is stopped, previous Master and Msdb .mdb and .ldf files moved into place and the server restarted, that any previous user database .mdb and .ldf files can be accessed by the SQL server.
Is this the case, or are there details missing?

Sponsored links

stad329
Posts: 1
Joined: 02 Dec 2014, 13:39

Re: Can I recover a damaged SQL Server 2008 database  Topic is solved

#2 Post by stad329 » 02 Dec 2014, 15:05

Hello ;) Try to solve this problem like this..
• Open your SQL Server Management Studio console. This application shortcut is available in the SQL Server directory in the Windows Start button.
• Enter the system administrator user name and password. SQL Server's administrator user name is "sa." This account is required for privileges to restore the database. If your restoring on a host provider server, use the administrator user name and password they supplied for your account.
• Right-click your database name and select "Attach." In the new window that opens, click the "Add" button to open a dialog box.
• Select your MDF file and press the "Ok" button. It may take several minutes to restore the database if it is a large file. Once the process is finished, browse your tables to verify the data. The database is now restored.

Or u can use this site: https://groups.google.com/forum/?hl=en# ... cCTaFcKYag

Locked

Who is online

Users browsing this forum: No registered users and 2 guests