Moving a database between two SQL Server with different patch levels

Hi,

I need to move a database from an instance running SQL Server 2000 SP3
to another running SQL Server 2000 SP2. Can I just use backup/restore
or detach/reattach and let SQL server take care of any downgrading (if
any).

Many thanks

GiovanniHi

I doubt if you can downgrade like this, and you may get spurious results. A
safer option may be to use the transfer wizard.

John

"Giovanni" <giovanni.clayden@.lstrillium.com> wrote in message
news:366e1de1.0410260757.7e48c961@.posting.google.c om...
> Hi,
> I need to move a database from an instance running SQL Server 2000 SP3
> to another running SQL Server 2000 SP2. Can I just use backup/restore
> or detach/reattach and let SQL server take care of any downgrading (if
> any).
> Many thanks
>
> Giovanni|||Giovanni (giovanni.clayden@.lstrillium.com) writes:
> I need to move a database from an instance running SQL Server 2000 SP3
> to another running SQL Server 2000 SP2. Can I just use backup/restore
> or detach/reattach and let SQL server take care of any downgrading (if
> any).

No. You will have to rebuild the database from scripts and bulk data in
or out. Or use the Transfer Wizard that John mentioned.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns958EEC2E2A9B3Yazorman@.127.0.0.1...
> Giovanni (giovanni.clayden@.lstrillium.com) writes:
> > I need to move a database from an instance running SQL Server 2000 SP3
> > to another running SQL Server 2000 SP2. Can I just use backup/restore
> > or detach/reattach and let SQL server take care of any downgrading (if
> > any).
> No. You will have to rebuild the database from scripts and bulk data in
> or out. Or use the Transfer Wizard that John mentioned.

You positive? Generally SP's only modify system databases. This is one of
those cases I'd suggest "try it, expect it to fail, but you may get lucky."

> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Greg D. Moore (Strider) (mooregr_deleteth1s@.greenms.com) writes:
> You positive? Generally SP's only modify system databases. This is one
> of those cases I'd suggest "try it, expect it to fail, but you may get
> lucky."

And they you later run into problems, and then you find out that is not
supported. Better safe than sorry, as they say.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

move db Win2000 SQL2000sp2 to Server 2003 sp3a

On my current install of Win 2000 Sql Server sp2 I tried to install sp3a. A
fter repeated attempts the server did not update. I got no errors and it lo
oked like it had installed on the default database but every time I check th
e version, I was on sp2. S
o now I have a new server with Server 2003 installed and will be moving my d
atabases over there. So I have installed Sql Server 2000 sp2. I will then
be installing sp3a. Will there be any problems with restoring the master, t
emp, and all over databases
from Win 2000 sp2 server TO Server 2003 sp3a server?
Thanks for any guidance you can provide.I would have thought doing this would be a bad idea, as the restored master,
temp, msdb db's etc would be a different version to most of the server.
You are probably better off trying to update it after restoring your dbs.
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Can not really do that because Server 2003 needs to have Sql Server 2000 sp3
a installed.

move db Win2000 SQL2000sp2 to Server 2003 sp3a

On my current install of Win 2000 Sql Server sp2 I tried to install sp3a. After repeated attempts the server did not update. I got no errors and it looked like it had installed on the default database but every time I check the version, I was on sp2. So now I have a new server with Server 2003 installed and will be moving my databases over there. So I have installed Sql Server 2000 sp2. I will then be installing sp3a. Will there be any problems with restoring the master, temp, and all over databases from Win 2000 sp2 server TO Server 2003 sp3a server?
Thanks for any guidance you can provide.I would have thought doing this would be a bad idea, as the restored master,
temp, msdb db's etc would be a different version to most of the server.
You are probably better off trying to update it after restoring your dbs.
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Can not really do that because Server 2003 needs to have Sql Server 2000 sp3a installed.