Hello there,
I would like to move [backup an SQL 2000 user database and restore it
on an SQL 2005 server] , the database is located on different drives
on the 2 servers. Are there any special considerations to take into
account, should I upgrade SQL 2000 to 2005 first?
Thank you, T

There should be no issue with BACKUP and RESTORE. You just have to specify
the MOVE options to identify the new locations for the files in your RESTORE
statement.

Linchi

"Tester" wrote:

> Hello there,
> I would like to move [backup an SQL 2000 user database and restore it
> on an SQL 2005 server] , the database is located on different drives
> on the 2 servers. Are there any special considerations to take into
> account, should I upgrade SQL 2000 to 2005 first?
> Thank you, T
>

In addition to what Linchi has already mentioned, SQL Server 2005 will
create schemas from your object owners so you may have to revisit your
database object permissions

"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:F047F0BB-65C2-4E6B-87CE-C89563CBB3DB@microsoft.com...
> There should be no issue with BACKUP and RESTORE. You just have to specify
> the MOVE options to identify the new locations for the files in your
> RESTORE
> statement.
>
> Linchi
>
> "Tester" wrote:
>
>> Hello there,
>> I would like to move [backup an SQL 2000 user database and restore it
>> on an SQL 2005 server] , the database is located on different drives
>> on the 2 servers. Are there any special considerations to take into
>> account, should I upgrade SQL 2000 to 2005 first?
>> Thank you, T
>>