Options
Unable To Restore System DB's
PDRegan
Posts: 12
Hi Guys,
Any ideas the best way to get around the following errors when attempting to restore the system db's, the problem has arose due to the fact that after installing SQL 2000 SP4 our system runs like a 3 legged dog, even after applying all the so-called hotfixes to the system.
Its been decided to go back to SP3a, Ive installed a test server with a clean version of SQL upto SP3a and with the company DB restored it works as it did before SP4, which proves to me that sp4 was microsofts way of pushing everbody to 2005, it may be pushing us to Oracle.
Anyway i digress
My problem is that any DTS packages that are saved to the msdb cant be restored. My only workaround currently is to restore a server upto SP4 again and export them out.
Following is the error msg we recieve:
Restoring msdb (database) from:
\SQL Data\BackUp\FULL_msdb_20060801_093858.sqb
Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
Server: Msg 3168
The backup of the system database on device SQLBACKUP_547B8847-2EED-44DE-A296-091D7B05A834 cannot be restored because it was created by a different version of the server (134219767) than this server (134218488).
SQL error code: 3168
Cheers
Pete
Any ideas the best way to get around the following errors when attempting to restore the system db's, the problem has arose due to the fact that after installing SQL 2000 SP4 our system runs like a 3 legged dog, even after applying all the so-called hotfixes to the system.
Its been decided to go back to SP3a, Ive installed a test server with a clean version of SQL upto SP3a and with the company DB restored it works as it did before SP4, which proves to me that sp4 was microsofts way of pushing everbody to 2005, it may be pushing us to Oracle.
Anyway i digress
My problem is that any DTS packages that are saved to the msdb cant be restored. My only workaround currently is to restore a server upto SP4 again and export them out.
Following is the error msg we recieve:
Restoring msdb (database) from:
\SQL Data\BackUp\FULL_msdb_20060801_093858.sqbServer: Msg 3013
RESTORE DATABASE is terminating abnormally.
Server: Msg 3168
The backup of the system database on device SQLBACKUP_547B8847-2EED-44DE-A296-091D7B05A834 cannot be restored because it was created by a different version of the server (134219767) than this server (134218488).
SQL error code: 3168
Cheers
Pete
There are only 10 types of people, those who get binary jokes and those who dont.
Comments
I don't think that we can help in this case, because the issue is that SQL 2000 requires you to restore a database to the same version (including service pack!) of SQL as the server that did the backup. SQL Backup can't work around this limitation.
- James
--
James Moore
Red Gate Software
Head of DBA Tools
Red Gate Software Ltd