An error occurred on a query to database master.

[kanewong]

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!

[SANDEEP_PILLAY]

As we understand from your mail, you receive an error "An error occurred on a query to database master." when you try to redirect the restore of a SQL server to a Backup server of same configuration.

This error can occur if the destination of the restore doesn't have the free space to contain the database files. Here is the document for your reference
http://support.veritas.com/docs/262416
If you use multiple jobs to restore a database, make sure that you specify the right recovery completion state (Leave database operational/ non-operational) .

Refer page no.1001 of the administrators guide of Backup Exec for general information on restoring SQL .Refer page no. 1009 for information on restoring master database of SQL 2000.

Refer page no. 1011 for information regarding redirect restore of SQL 2000.

You can download the administrators guide from the following link
http://support.veritas.com/docs/266190

Please refer to the following technote as an additional information
http://seer.support.veritas.com/docs/248591.htm

Make sure that mssqlserver service is logged in as system account.

We hope this helps.