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
- 6645 Views
- Apple, I also Faced
- E-Mail Answers
Answer Posted / lokevis32
- Insert the SQL Server Installation disc into the server computer's disc drive. Access the drive from your computer by clicking "My Computer" from the desktop and double-clicking the disc drive icon.
- Run setup.exe from the SQL server installation disc. The setup command should be located in the disc's root directory. Run the setup program by double-clicking "setup.exe." This will bring up the SQL server installation center page.
- Click the "Maintenance" button located on the lefthand side of the navigation window. Select "Repair" and then choose the language you wish the program to be presented in after installation. Click "Next" to continue. This will run setup routines, making sure your computer has all the prerequisites installed to correctly run SQL server 2008. Click "OK" or "Install" to continue. This will bring you to the Select Instance page.
- Select the instance you want to repair. This will reconfigure your server using automatic backups to a time the server was working correctly and reinstall any corrupted information. Click "Next." The repair rules will automatically verify the operation. Click "Next" to continue. This will take you to the Ready to Repair page.
- Click "Repair" and SQL server disc will run its repair function. The repair progress bar will show the completion level of the repair. Once the repair function is complete, click "Finish" to exit the repair program. Reboot the server machine to complete the repair.
Or you can visit: SQL Server Fix Toolbox http://www.fixsqldatabase.com/
Visit this site, it can be helpful:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are different types of data sources?
What are system databases into sql server (2005/2008)?
How to list all tables in the database using odbc_tables()?
What is table constraint?
What is rs.exe utility?
How to create a testing table with test data in ms sql server?
What is partition, how will you implement it? : sql server analysis services, ssas
Explain various data region available in ssrs with their use?
Name three of the features managed by the surface area configuration tool? : sql server security
How do I start sql server 2017?
How can you insert null values in a column while inserting the data?
Can you always create a cache of a report?
Is INSTEAD OF trigger directly applicable to Table ?
What does asynchronous call backs means?
Why would you call update statistics?
