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
- 6907 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 language is sql server written in?
How many types of attribute relationships are there? : sql server analysis services, ssas
Explain what is sql server english query?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Can a table have 2 primary keys?
How retrieve field names from the table in SQL through JAVA code?
What is mean by dml?
Give the query of getting last two records from the table in SQL SERVER?
What is the difference between NOROW and LOCKROW?
Difference between DELETE and TRUNCATE?
What does it mean to normalize a database and why would you do it?
Explain what is the difference between a local and a global temporary table?
How do you delete a data source?
What is multi-statement table-value user-defined function?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
