How to Repair SQL Server 2008

by John Heller

Microsoft SQL Server 2008 is a database server designed mainly for business uses. If you have installed Microsoft SQL server 2008 and the program was corrupted because of a software or installation error you can repair the program using the troubleshooting tools on the installation media.

1

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.

2

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.

3

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.

4

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.

5

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.

Items you will need

About the Author

John Heller has been a freelance writer and author since 1998, beginning in college, and has written content for publishers such as Game Wire and Demand Studios. He focuses on and enjoys writing and blogging about health, technology, gaming, recreation, food and lifestyles for many online and print publications.

Photo Credits

  • photo_camera server cpu image by TEA from Fotolia.com