Hi

I need to restore a SQL server 7.0 msdb backup onto a SQL
Server 2000 server. The restore failed because of version
conflict problem. It looks like I only get this error when
restoring system databases. User databases were restored
with no problem. Please could someone guide me in the
right direction as how this can be achieved?

Thanks in advance

Alex

Report this post to a moderator

Script your jobs etc from the original MSDB and apply those scripts to the SQL2K machine.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver


"Alex Au" <alex.au@ace-ina.com> wrote in message
news:08ce01c29c46$982b3f10$d2f
82ecf@TK2MSFTNGXA09...
> Hi
>
> I need to restore a SQL server 7.0 msdb backup onto a SQL
> Server 2000 server. The restore failed because of version
> conflict problem. It looks like I only get this error when
> restoring system databases. User databases were restored
> with no problem. Please could someone guide me in the
> right direction as how this can be achieved?
>
> Thanks in advance
>
> Alex

Report this post to a moderator

Hi

> I need to restore a SQL server 7.0 msdb backup onto a SQL
> Server 2000 server. <skip> Please could someone guide me in the
> right direction as how this can be achieved?

It depends of what do you want to achieve.

You can script most of the objects residing in msdb (jobs, backups, etc) and
run the script on you SQL2K server.

Oleg.

Report this post to a moderator

Thanks for your advice.

Alex
>-----Original Message-----
>Script your jobs etc from the original MSDB and apply
those scripts to the SQL2K machine.
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>
>"Alex Au" <alex.au@ace-ina.com> wrote in message
> news:08ce01c29c46$982b3f10$d2f
82ecf@TK2MSFTNGXA09...
>> Hi
>>
>> I need to restore a SQL server 7.0 msdb backup onto a
SQL
>> Server 2000 server. The restore failed because of
version
>> conflict problem. It looks like I only get this error
when
>> restoring system databases. User databases were restored
>> with no problem. Please could someone guide me in the
>> right direction as how this can be achieved?
>>
>> Thanks in advance
>>
>> Alex
>
>
>.
>

Report this post to a moderator

Thanks for your advice

Alex
>-----Original Message-----
>Hi
>
>> I need to restore a SQL server 7.0 msdb backup onto a
SQL
>> Server 2000 server. <skip> Please could someone guide
me in the
>> right direction as how this can be achieved?
>
>It depends of what do you want to achieve.
>
>You can script most of the objects residing in msdb
(jobs, backups, etc) and
>run the script on you SQL2K server.
>
>Oleg.
>
>
>
>.
>

Report this post to a moderator