restoring master on sp3 to sp2

I have torestore a master database from sql server 2000 running sp2 onto a
sql server 2000 running sp3. Would it cause any issues? Thanks.Hi
"sharman" wrote:
> I have torestore a master database from sql server 2000 running sp2 onto a
> sql server 2000 running sp3. Would it cause any issues? Thanks.
Why?
You should have backed up the system database post upgrade (the installation
does tell you to do that!!)
John|||Hi John,
I think I haven't phrased my question correctly. My question is can I
restore master, model and msdb on sql 2000 sp3 from backups that were backed
up on SQL 2000 SP2?
"John Bell" wrote:
> Hi
> "sharman" wrote:
> > I have torestore a master database from sql server 2000 running sp2 onto a
> > sql server 2000 running sp3. Would it cause any issues? Thanks.
> Why?
> You should have backed up the system database post upgrade (the installation
> does tell you to do that!!)
> John|||Hi
On Jun 27, 5:14 pm, sharman <shar...@.discussions.microsoft.com> wrote:
> Hi John,
> I think I haven't phrased my question correctly. My question is can I
> restore master, model and msdb on sql 2000 sp3 from backups that were backed
> up on SQL 2000 SP2?
>
> "John Bell" wrote:
> > Hi
> > "sharman" wrote:
> > > I have torestore a master database from sql server 2000 running sp2 onto a
> > > sql server 2000 running sp3. Would it cause any issues? Thanks.
> > Why?
> > You should have backed up the system database post upgrade (the installation
> > does tell you to do that!!)
> > John- Hide quoted text -
> - Show quoted text -
You can try this!! AFAIK there is no guarantee that something has
changed in a service pack or that it will work correctly, therefore it
is best to restore the same level.
John