February 5, 2010 at 3:20 am
i want to restore msdb on different location
but getting following error
Msg 3168, Level 16, State 1, Line 1
The backup of the system database on the device D:\test\MSSQL.5\MSSQL\Backup\Msdb_backup_20100205.bak cannot be restored because it was created by a different version of the server (9.00.4262) than this server (9.00.4035).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
How can i do it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 5, 2010 at 6:15 am
You said that you are trying to restore it to a different location.Does the destination server has same version of SQL Server as of the the source server?Can you try restoring on the server which has same version if possible?
Vivek
February 5, 2010 at 6:19 am
version are different , as mentioned in prior post
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 5, 2010 at 6:28 am
it is not possible to restore system databases to another server which is at a different patch level. You would have to upgrade the target server to be at the same version, or script out the objects in msdb and manually load them in.
---------------------------------------------------------------------
February 5, 2010 at 6:39 am
I was asking have you tried restoring on the server with same version.:laugh:If yes,do you get the same error message.
And, in case of different versions, I guess George is right.
Vivek
February 5, 2010 at 6:48 am
Remember that a backup of a lower version / patch level would work when tried to restore on a higher version / patch level. But the higher version / patch level backup would not work on the lower versions.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 5, 2010 at 7:00 am
Bru Medishetty (2/5/2010)
Remember that a backup of a lower version / patch level would work when tried to restore on a higher version / patch level. But the higher version / patch level backup would not work on the lower versions.
you sure, Bru?
---------------------------------------------------------------------
February 5, 2010 at 12:21 pm
BRU is TRUe.
MJ
February 5, 2010 at 4:41 pm
just to confirm it I tried to restore an msdb database from a 2005 SP2 server (3042) onto an SP3 server (4035) - i.e. lower version to higher, and got the same error as the OP.
Other than that problem I would advise against restoring msdb to a server of a different name anyway. it causes lots of problems, in particular with any maintenance plans carried across.
---------------------------------------------------------------------
February 6, 2010 at 7:51 am
George,
I would try this as well and update.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 7, 2010 at 2:20 pm
Best practices is not to restore system databases, i have not seen in any environment DBA' s restoring system databases until and unless mandatory. Why are you trying to restore MSDB? Is there any particular reason you are trying to restore rather than exporting jobs using script as George mentioned?
If you still want to restore, here is work around, change the compatibility level of database to 2000 (80) take a backup and restore at destination server. Remember you will loose all the features of 2005 (90) and also the database compatibility level will be 2000 (80) at the destination server after restore. After restore you should be able to change the compatibility level of the database at destination server to 2005 (90).
Let me know how it goes!
Enjoy!
February 7, 2010 at 10:57 pm
i didnt try to restore the MSDB instead i transfered jobs with SSIS package.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 8, 2010 at 10:29 pm
Bhuvnesh (2/7/2010)
i didnt try to restore the MSDB instead i transfered jobs with SSIS package.
Ok, So does it mean that you were trying to restore the msdb database to transfer the jobs/packages?
February 8, 2010 at 11:07 pm
yes i was restoring MSDB for login and jobs perspective.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply