database move

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tester - 14 Jul 2008 19:45 GMT

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

Reply to this Message

Linchi Shea - 14 Jul 2008 20:00 GMT

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

> 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

Reply to this Message

bass_player - 15 Jul 2008 06:47 GMT

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

> 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
[quoted text clipped - 9 lines]
>> account, should I upgrade SQL 2000 to 2005 first?
>> Thank you, T

Reply to this Message