I need to do some testing/upgrade work on our SQL-based database system in order to upgrade our front-end client software from 2.1 to 2.7.
The upgrade/testing process isn’t too bad, just a case of updating a few table schemas & introducing new fields/types. Once the database work is complete, it’s just a case of installing the latest client software.
However, I’m having some issues restoring the database to a test environment...
I’ve restored the disk image of the server (from Acronis True Image) onto a spare PC and it’s working great as an offline carbon copy of the server configuration. Next, I added in a 160GB HDD into the test PC ready to restore our SQL database to.
Currently, the database is around 90GB. First of all, I verified the backup:
“restore filelistonly from disk = ‘D:\SQLBackup\SERVERNAME-SQL-BACKUP-20110309.060035.420-FULL.bak’.
The result of this command was fine and the 3 data files were listed:
ProNet_Data – 90GB – ProNet_Data.mdf
ProNet_CVDATA – 1MB – ProNet_CVData.ndf
ProNet_Log – 2GB – ProNet_Log.ldf
Next, I used the following command to attempt a restore (note: the disk I’m restoring the DB to is labelled E: on both the live and test server):
“Restore database pronet from disk = ‘D:\SQLBackup\SERVERNAME-SQL-BACKUP-20110309.060035.420-FULL.bak’.”
This command runs for 33 mins, then fails with the following error:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally
When I go to Enterprise Manager, the database is greyed out and has the (Loading) status.
I cannot understand why this error is occurring. There is 134GB free on the hard disk I’m restoring it too and there’s no other processes taking over the machine.
I've tried formatting the spare HDD so it's completely empty and tried restoring the disk image to another PC - the problem still remains the same.
Please could you let me know your thoughts as I’m desperate to start work on this upgrade project but cannot do anything until I get a test database restored. Once the client is up to date we'll be upgrading to SQL 2005/2008.
If I get time this weekend, I'll VPN-in and run a restore on the live server while no users are logged on. (restore it as another database name in a different folder to the live DB).
Any questions, feel free to ask.
Thanks in advance!