I restored all my SQL databases including "master", "model", "msdb"... database to another server. However at the end of the restore of "master database" I received this error "An error occurred on a query to database master."
And when I restored the rest databases, I also received this error message
"An error occurred on a query to database model.
The system database cannot be moved by RESTORE."
When I looked at the database in new server, I can see all restored database under Enterprise Manager of SQL 2000.
How can I avoid this thing?
While doing restore, the SQL2000 server was refreshed with a new copy and no other database was there except those system database like "master", "msdb"...
How can I make sure that the database restored on the new server can be 100% successfully?
Thanks!