How do you get a copy of a database from a sql 2000 server to a sql 2005
database with the same database name?
Thanks for any help.
Bob

Hi,

2 methods:-

1. Backup the database in SQL 2000 using Backup Database and use Restore
Database in SQL 2005 using the same name,

2. Detach the database in SQL 2000, copy the MDF and LDF to SQL 2005 folder
and then attach using the same name

Thanks
Hari
SQL Server MVP

"rdufour" <bdufour (AT) sgiims (DOT) com> wrote