dettach SQL 7 and attach SQL 2000 ?

Can I dettach a database from a SQL 7 server and attach it to a SQL 2000
server?
GavYes, you can do it this way, it is going to be upgraded to 2000
automatically. But leave a copy in SQL 7.0 just in case!
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
"Gav" <gavin.metcalfe@.nospam.btinternet.com> wrote in message
news:cbgo1r$agk$1@.hercules.btinternet.com...
> Can I dettach a database from a SQL 7 server and attach it to a SQL 2000
> server?
> Gav
>|||Hi,
Yes, you can. Detach the database from SQL 7 server, copy the MDF and LDF to
SQL 2000 server and
attach it. After attaching , To achieve optimal performance, update all
statistics on the upgraded database by running sp_updatestats
FYI,
The SP_ATTACH_DB will automatically upgrade the database structure from SQL
7 to sql 2000.
Look into the sample result of sp_attach_db. Here I attached a database
named GCC to SQL 2000. The source was database was SQL 7.0
Converting database 'gcc' from version 515 to the current version 539.
Database 'gcc' running the upgrade step from version 515 to version 524.
Database 'gcc' running the upgrade step from version 524 to version 525.
Database 'gcc' running the upgrade step from version 525 to version 526.
Database 'gcc' running the upgrade step from version 526 to version 527.
Database 'gcc' running the upgrade step from version 527 to version 528.
Database 'gcc' running the upgrade step from version 528 to version 529.
Database 'gcc' running the upgrade step from version 529 to version 530.
Database 'gcc' running the upgrade step from version 530 to version 531.
Database 'gcc' running the upgrade step from version 531 to version 532.
Database 'gcc' running the upgrade step from version 532 to version 533.
Database 'gcc' running the upgrade step from version 533 to version 534.
Database 'gcc' running the upgrade step from version 534 to version 535.
Database 'gcc' running the upgrade step from version 535 to version 536.
Database 'gcc' running the upgrade step from version 536 to version 537.
Database 'gcc' running the upgrade step from version 537 to version 538.
Database 'gcc' running the upgrade step from version 538 to version 539.
To achieve optimal performance, update all statistics on the 'gcc' database
by running sp_updatestats.
Thanks
Hari
MCDBA
"Gav" <gavin.metcalfe@.nospam.btinternet.com> wrote in message
news:cbgo1r$agk$1@.hercules.btinternet.com...
> Can I dettach a database from a SQL 7 server and attach it to a SQL 2000
> server?
> Gav
>|||Yes, with sp_detach_db and sp_attach_db. The database will be upgraded
automatically when you attach it. Make sure you have a backup first though.
Remember you may need to re-create your logins on the SQL2000 server.
Also, refer to:
http://support.microsoft.com/defaul...kb;en-us;314546
David Portas
SQL Server MVP
--|||Thanks for all your input. I've tried it on my test machine and it worked
spot on. Just didn't want to try it and find I had to spend hours restoring
the 220GB database.
Gav
"Gav" <gavin.metcalfe@.nospam.btinternet.com> wrote in message
news:cbgo1r$agk$1@.hercules.btinternet.com...
> Can I dettach a database from a SQL 7 server and attach it to a SQL 2000
> server?
> Gav
>