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