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
- 6792 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
explain different types of joins? : Sql server database administration
What is user-defined multi-statement table-valued function?
What is a bit datatype?
What are four major operators that can be used to combine conditions on a where clause?
Benefits of Stored Procedures?
Do you know concepts and capabilities of sql server?
Do you know the cursor optimization tips?
How to execute a sql statement using odbc_exec()?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What is the openxml statement in sql server?
What is the bookmark lookup and rid lookup?
Explain transaction server distributed transaction?
Do you know what is fill factor and pad index?
How can I create a report based on a query? : sql server management studio
What is schemabinding a view?
