Backup of SQL fails - wrong user access
Hi,
Trying to figure out an issue with backup an sql server 2008 databases on a remote server.
Below is the erros I am getting. Now I have looked at TECH144230 and TECH69132
which basically says to check to make sure that the logon account has the sysadmin role on the DB which it does. So I am not sure what the next step is.
Backup- PBCA-DOC1V-79-57344-65088 - WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cannot be completed.
User 'guest' does not have permission to run DBCC checkdb for database 'master'.
V-79-57344-65088 - WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cannot be completed.
User 'guest' does not have permission to run DBCC checkdb for database 'msdb'.
Backup- PBCA-DOC1\CCHDM_SQLEXP2008V-79-57344-37951 - Database master has failed to freeze for the snapshot backup.
V-79-57344-37951 - Database msdb has failed to freeze for the snapshot backup.
It turns out the database that it was failing on is one we do not need to backup anyway.
It was a temporary one that the 3rd party vendor setup, so on I removed that from the job it backed up the main db fine
