You only need to backup the database in the SQL2000 and a restore in the SQL2005..

Be carefull with the logins, and in the Options, you can change the way of...

Hello,

You can execute sp_who2 to see the connections of the Database.. another way is to use the Activity Monitor.

Regards

Hello,

This error may be because in the database can have another files that not are in the DB, to see this, you can go to the Properties of the Database...

I use the follow sentence:

Robocopy e:\mssql\backup\bkAP.bak \\DestinationServer\f$\mssql\backup\bkAP.bak /MIR /SEC /Log:c:\temp\bkAP.log

The parameter /log if because I have a script that check if the robocopy has finish OK.

I hope that this POST...