I recieved the follwoing message from the backup job of my database manitean
nce plan:
What does this mean? Can I not make a backup if users are on the system? Wha
t do I change?
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'P
G_PROD' as 'PG_PROD\SQLAGENT' (trusted)
Starting maintenance plan 'PayCentralFULLSunday' on 4/4/2004 12:30:00 AM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]
91;ODBC SQL Server Driver][SQL Server]Database state cannot be changed w
hile other users are using the database 'PAYCENTRAL'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE st
atement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[1] Database PAYCENTRAL: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
91;ODBC SQL Server Driver][SQL Server]Repair statement not processed. Da
tabase needs to be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement
not processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
Deleting old text reports... 1 file(s) deleted.
End of maintenance plan 'PayCentralFULLSunday' on 4/4/2004 12:30:00 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Thanks,
ThomasLLThomas
It's not your backup. In your plan under the database integrity check you ha
ve ticked attempt to repair any minor problems. SQL Server is attempting to
set the database to single user mode so it can do this. It is not required,
untick the box. Don't forge
t to check the output for errors and if you get any arrange to run dbcc chec
kdb with applicable repair option at a time that no users are on the system.
Hope this helps
John
No comments:
Post a Comment