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
- 6799 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 timestamp datatype?
What are the ways available in sql server to execute sql statements?
last function used in MS Access to convert sql what function will use in sql
what are the different stages of Report Processing?
What causes index fragmentation?
What are the different Topologies in which Replication can be configured?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What methods do you follow to protect from sql injection attack?
what is the maximum size of a row? : Sql server database administration
what is a live lock? : Sql server database administration
What is the difference between Stored Procedures and triggers?
Explain the difference between cross join and full outer join?
What is a View ? Can we insert, Update and delete a view?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to start sql server browser service?
