Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-19 : 08:32:49
|
| Anhtuan writes "Microsoft (R) SQLMaint Utility, Version 6.50.240Copyright (C) Microsoft Corporation, 1995 - 1996Logged on to SQL Server 'CFCPEGAM' as 'sa' (trusted)Starting maintenance of database 'PEG' on Sun Jul 14 02:45:00 2002[1] Check Data Linkage... ** Execution Time: 1 hrs, 19 mins, 41 secs **[2] Check Data Allocation... WARNING: Database PEG is currently being used by 19 user(s). This may cause spurious problems to be reported. ** Execution Time: 0 hrs, 7 mins, 45 secs **[3] Check System Data... The following errors were found:Database Corrupt: The last checkpoint in Sysdatabases is incorrect. Syslogs recorded a different checkpoint ** Execution Time: 0 hrs, 0 mins, 1 secs **[4] Update Statistics... ** Execution Time: 0 hrs, 3 mins, 24 secs **End of maintenance for database 'PEG' on Sun Jul 14 04:15:51 2002SQLMAINT.EXE Process Exit Code: 1 (Failed)What do I do ?" |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-07-19 : 15:15:16
|
| Begin by running DBCC CHECKDB. Refer to BOL.HTHs solart |
 |
|
|
bm1000
Starting Member
37 Posts |
Posted - 2002-07-19 : 17:00:46
|
quote:
Anhtuan writes "Microsoft (R) SQLMaint Utility, Version 6.50.240Copyright (C) Microsoft Corporation, 1995 - 1996Logged on to SQL Server 'CFCPEGAM' as 'sa' (trusted)Starting maintenance of database 'PEG' on Sun Jul 14 02:45:00 2002[1] Check Data Linkage... ** Execution Time: 1 hrs, 19 mins, 41 secs **[2] Check Data Allocation... WARNING: Database PEG is currently being used by 19 user(s). This may cause spurious problems to be reported. ** Execution Time: 0 hrs, 7 mins, 45 secs **[3] Check System Data... The following errors were found:Database Corrupt: The last checkpoint in Sysdatabases is incorrect. Syslogs recorded a different checkpoint ** Execution Time: 0 hrs, 0 mins, 1 secs **[4] Update Statistics... ** Execution Time: 0 hrs, 3 mins, 24 secs **End of maintenance for database 'PEG' on Sun Jul 14 04:15:51 2002SQLMAINT.EXE Process Exit Code: 1 (Failed)What do I do ?"
You probably do not have a problem. Have all of your users get out of the database and execute dbcc checkcatalog. If it succeeds then you are okay. In the future, try to schedule dbccs during an outage window when no one is accessing the database. |
|
|
|
|
|
|
|
|
SQL Maintenance job failed