Copy database from SqlServer 2000 to 2005

Hi;
How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
Server 2000 instances we do a backup/restore but 2005 won't do a restore of
a
2000 backup.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmDavid Thielen wrote:
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore o
f a
> 2000 backup.
>
Sure it will. You can restore a 2000 backup to a 2005 server, but you
can't go the other way.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We migrated all of our databases from 2000 to 2005 last year - my
memory isn't very clear now but I believe we did detach/reattach of the
database files. Basically you just copy over the ldf, mdf and ndf files
to the new server, then attach them through 2005 management studio,
making sure to specify the new file locations on the new server...
David Thielen wrote:
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore o
f a
> 2000 backup.
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm|||What do you mean wont do a restore of 2000 backup. It should, I did it more
then a few times. You cant restore 2005 backup on 2000...
MC
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:7CBA4B6A-BAC8-44D9-9152-637A5D6153FD@.microsoft.com...
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore
> of a
> 2000 backup.
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>|||yes, the other posters are correct - you can restore a 2000 db on 2005,
just not the other way around
also keep in mind, once you restore the db's you can change the
compatibility of a given database to match that of 2005, as the
compatibility will be 2000 by default (however be careful when doing
this as you may lose old functionality you may still need)
there is a database upgrade advisor tool available from microsoft,
avail as a download - probably best to run this first before changing
the db compatibility, esp on a production machine
just my 2 cents
MC wrote:[vbcol=seagreen]
> What do you mean wont do a restore of 2000 backup. It should, I did it mor
e
> then a few times. You cant restore 2005 backup on 2000...
>
> MC
>
> "David Thielen" <thielen@.nospam.nospam> wrote in message
> news:7CBA4B6A-BAC8-44D9-9152-637A5D6153FD@.microsoft.com...