MS SQL server master database restore fails

[Andre_Visse_2]

Hi,

I am having problems with MS SQL 2000 master database restore. I have BackupExec 10.0 with SQL agent installed and the backup does not show any errors. When restoring other databases to SQL server it works just fine, but when you put sql to single user mode and try to restore master, it fails with access denied error.

I double checked that backupexec account has domain admin rights and also has access to the following registry keys on SQL server:
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer

I have also tried to use sa account to restore the database - no luck.

Any help would really be appreciated,

Andre Visse

[Amruta_Purandar]

Hello,

Please specify the exact error message.
Are you performing a redirected restore?

NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.

[Andre_Visse_2]

Hi,

Thanks for the response!
The exact error message in backupexec log is:

V-79-57344-33938 -
An error occurred on a query to database master.
V-79-57344-33938 - RESTORE DATABASE is terminating abnormally.

and job completion status>

Completed status: Failed
Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors

Andre