Backup of SQL 2008 Fails with "WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cannot be completed"
| Article:TECH69132 | | | Created: 2009-01-26 | | | Updated: 2011-07-29 | | | Article URL http://www.symantec.com/docs/TECH69132 |
Problem
Backup of SQL 2008 Fails with "WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cannot be completed"
Error
V-79-57344-65088 - WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cannot be completed.
User '
Cause
The logon account does not have the Sysadmin role.
Solution
1. On the SQL 2008 server, open the SQL Studio Management console.
2. Browse to Security > Logins. Make sure that the logon account used for backing up SQL database exists there.
3. Add the Logon account to the Sysadmin Role.
4. Now try running the backup of the SQL 2008 database again.
2. Browse to Security > Logins. Make sure that the logon account used for backing up SQL database exists there.
3. Add the Logon account to the Sysadmin Role.
4. Now try running the backup of the SQL 2008 database again.
|
|
| Value | V-79-57344-65088 |
| Description | WARNING: The DBCC NEWALLOC command requires SA rights. The consistency check cannot be completed. |
Legacy ID
321617
Article URL http://www.symantec.com/docs/TECH69132
Terms of use for this information are found in Legal Notices
Thank you.