|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to convert MSDB from SP3 to SP4Is it possible to take the MSDB database bakup file from a SQL2000 SP3
server and convert it to SP4 so it can be restored to an SP4 server, without updating the SP3 server to SP4?? Hi,
there is no way to update just the database backup to SP4. The best way would be then to setup another MSDE on a interim server restore the MSDB to the server, update to SP4 and then restore it to the destination server. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- restoring the database to an Sp4 server should do the upgrade for you.
HTH John Show quoteHide quote "msnews.microsoft.com" wrote: > Is it possible to take the MSDB database bakup file from a SQL2000 SP3 > server and convert it to SP4 so it can be restored to an SP4 server, without > updating the SP3 server to SP4?? > > > Thanks to both you and Jen!! I thought it would require as Jen said.. I
will create a new instance apply SP3 restore to that then upgrade that to SP4 back it up from there and then restore it to the SP4 production server.. When I attempted to restore the SP3 MSDB backup I got this error message >> The backup of the system database on device <FileNAME> cannot be restored because it was created by a different version of the server (##########) than this server (XXXXXXXXX). Show quoteHide quote "John Bandettini" <JohnBandett***@discussions.microsoft.com> wrote in message news:5D7AD1A2-8E63-41E0-9D2F-78447E02ECA7@microsoft.com... > restoring the database to an Sp4 server should do the upgrade for you. > > HTH > > John > > "msnews.microsoft.com" wrote: > >> Is it possible to take the MSDB database bakup file from a SQL2000 SP3 >> server and convert it to SP4 so it can be restored to an SP4 server, >> without >> updating the SP3 server to SP4?? >> >> >> As you found out, the system databases cannot just be restored to another
server on another build of SQL. For one it will have the server name from the backup. Restoring a system database can work for a DRP but it isn't really just another database to restore to some other server on a higher SQL build. Chris Wood Show quoteHide quote "msnews.microsoft.com" <breichenb***@istate.com> wrote in message news:esk9wqAgGHA.4940@TK2MSFTNGP05.phx.gbl... > Thanks to both you and Jen!! I thought it would require as Jen said.. I > will create a new instance apply SP3 restore to that then upgrade that to > SP4 back it up from there and then restore it to the SP4 production > server.. > > When I attempted to restore the SP3 MSDB backup I got this error message > >> > The backup of the system database on device <FileNAME> cannot be restored > because it was created by a different version of the server (##########) > than this server (XXXXXXXXX). > > "John Bandettini" <JohnBandett***@discussions.microsoft.com> wrote in > message news:5D7AD1A2-8E63-41E0-9D2F-78447E02ECA7@microsoft.com... >> restoring the database to an Sp4 server should do the upgrade for you. >> >> HTH >> >> John >> >> "msnews.microsoft.com" wrote: >> >>> Is it possible to take the MSDB database bakup file from a SQL2000 SP3 >>> server and convert it to SP4 so it can be restored to an SP4 server, >>> without >>> updating the SP3 server to SP4?? >>> >>> >>> > > Actually I had not completely discovered exactly what you say here,
as I have not yet had time to create the new instance..... But There is more to my story, sorry let me fill in some blanks. The SP3 server has the same name as the SP4 server. Both Default SQL 2k installs The SP4 server will replace the SP3 server, and is not yet attached to the DOMAIN. I am now thinking that I will not be able to restore the MSDB backup to an Instance Named TEST, and that it will only restore to a default instance SP3. Show quoteHide quote "Chris Wood" <anonym***@discussions.microsoft.com> wrote in message news:uNvmWNBgGHA.4864@TK2MSFTNGP05.phx.gbl... > As you found out, the system databases cannot just be restored to another > server on another build of SQL. For one it will have the server name from > the backup. Restoring a system database can work for a DRP but it isn't > really just another database to restore to some other server on a higher > SQL build. > > Chris Wood > > "msnews.microsoft.com" <breichenb***@istate.com> wrote in message > news:esk9wqAgGHA.4940@TK2MSFTNGP05.phx.gbl... >> Thanks to both you and Jen!! I thought it would require as Jen said.. I >> will create a new instance apply SP3 restore to that then upgrade that to >> SP4 back it up from there and then restore it to the SP4 production >> server.. >> >> When I attempted to restore the SP3 MSDB backup I got this error message >> >> >> The backup of the system database on device <FileNAME> cannot be restored >> because it was created by a different version of the server (##########) >> than this server (XXXXXXXXX). >> >> "John Bandettini" <JohnBandett***@discussions.microsoft.com> wrote in >> message news:5D7AD1A2-8E63-41E0-9D2F-78447E02ECA7@microsoft.com... >>> restoring the database to an Sp4 server should do the upgrade for you. >>> >>> HTH >>> >>> John >>> >>> "msnews.microsoft.com" wrote: >>> >>>> Is it possible to take the MSDB database bakup file from a SQL2000 SP3 >>>> server and convert it to SP4 so it can be restored to an SP4 server, >>>> without >>>> updating the SP3 server to SP4?? >>>> >>>> >>>> >> >> > >  
Thread options
Other interesting topics
Indexes on Joined Columns
Log Shipping Failover Visual Studio Install and SQL install sql server 2000 & update record Newbie - Help with Constraints Incremental updation Escpae characters When I backup my msdb database, it will also backup all DTS package ? SQLSERVERAGENT ERROR 1075: The dependancy service does not exist.. Query Timout |
|||||||||||||||||||||||
