Interested to Buy Any Domain ? << Click Here >> for more details...
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?
- 3 Answers
- 6904 Views
- Apple, I also Faced
- E-Mail Answers
Answer Posted / morenobelm3
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?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are locks in sql?
What are the two authentication modes in sql server?
What are click through reports?
Explain the difference between functions and stored procedures in sql server?
What is the difference between Triggers and Stored Procedure?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What are system databases into sql server (2005/2008) : sql server database administration
What are indexers?
What is data modeling and Reterminal integrity?
Define left outer join?
How to modify existing triggers using "alter trigger"?
what method you can use to reduce the overhead of Reporting Services data sources?
what are the Prerequisites for Replication?
What is inner join in sql server joins?
What is it’s similarity with sql server?
