Nov 28, 2014

How to fix error while restoring a Sql Database using MSSQL 2005?

When i try to restore a DB from a database backup file i get the following error after 10% of the data has been restored

System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "dbName" as read from the backup set.(Microsoft.Sqlserver.Smo,



Does anybody have a fix for this or know what it means? Please help.

12/02/2014
Hi!)

- 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.


12/01/2014


• Open your SQL Server Management Studio console. This application shortcut is available in the SQL Server directory in the Windows Start button.

• Enter the system administrator user name and password. SQL Server's administrator user name is "sa." This account is required for privileges to restore the database. If your restoring on a host provider server, use the administrator user name and password they supplied for your account.

• Right-click your database name and select "Attach." In the new window that opens, click the "Add" button to open a dialog box.

• Select your MDF file and press the "Ok" button. It may take several minutes to restore the database if it is a large file. Once the process is finished, browse your tables to verify the data. The database is now restored.


12/01/2014
Number6 has a good answer for this, but here's a link to another page that you might find useful:

http://technet.microsoft.com/en-us/sqlserver/bb671245.aspx
11/28/2014
A quick search showed that someone else had this same issue 5 years ago. There was a possible solution posted on expert exchange. Unfortunately, I can't post it here because it contains HTML scrips that aren't properly nested:
http://www.experts-exchange.com/Database/MS-SQL-Server/SQL-Server-2005/Q_24922751.html
Answer this