I'm planning to move a database called ABC from server A to server B.
I'm using SQL Server 2000.
To achieve that I was thinking of performing the following steps:
1) take a full backup of database ABC on server A;
2) copy over the network the backup of ABC on to server B;
3) rebuild from the backup the database ABC on server B.
My question is. Whatelse do I have to do?
How can I also move loggins and all other objects associated with this database?
The database is used to store data for an application used by some users. Exactly, which others steps do I have to perform to make sure that the users will not have any problem when we database will be move to server B?
Which are the most common problems I may come accross and how solve them?