Maintenance plan - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Maintenance plan

Author

Topic

antispamfixit
Starting Member

2 Posts

Posted - 2010-08-12 : 10:36:40

Can someone help me interpret these log files?

=====

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4053
Report was generated on "DBASE".
Maintenance Plan: Rebuild Index
Duration: 12:57:39
Status: Succeeded.
Details:

=====

^
This is the log file of an offline index rebuild. It's supposed to last 12 minutes (or is that hours?) but while it is rebuilding I can still access the database. Is that normal for an offline rebuild?

antispamfixit
Starting Member

2 Posts

Posted - 2010-08-12 : 10:42:19

Another problem I have:

This is from a log file backup that happens every 15 minutes.

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4053
Report was generated on "DBASE".
Maintenance Plan: Backup Logfiles
Duration: 00:00:03
Status: Warning: One or more tasks failed..
Details:
Back Up Database (Transaction Log) (DBASE)
Backup Database on Local server connection
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All databases
Type: Transaction Log
Append existing
Task start: 2010-08-12T02:45:03.
Task end: 2010-08-12T02:45:04.
Failed:(0) Database 'Zman opleiding' will not be backed up because it does not have its recovery model set to Full or BulkLogged.

^
This is normal, I guess? I read the help files and backing up the log files is a feature only for full backup recovery models. I'm not so worried about it.

=====

Back Up Database (Transaction Log) (DBASE)
Backup Database on Local server connection
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All databases
Type: Transaction Log
Append existing
Task start: 2010-08-12T02:45:04.
Task end: 2010-08-12T02:45:06.
Failed:(-1073548784) Executing the query "BACKUP LOG [Zman Navision Augustus] TO DISK = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Backup\\Zman Navision Augustus_backup_201008120245.trn' WITH NOFORMAT, NOINIT, NAME = N'Zman Navision Augustus_backup_20100812024504', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Cannot open database 'Zman Navision Augustus' version 0. Upgrade the database to the latest version.
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

=====

^
This is worrying me!!

!!

This is a production database. The logs must have been growing for 2 weeks now... How can I get it backed up, properly and safely?

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2010-08-12 : 23:44:15

Your first issue - is 12 hours, and you can still access any table where the clustered index is not currently being rebuilt. When you access a table where one of the non clustered indexes is being rebuilt, that index is offline and won't be used by the query.

Your second issue is very clear - you have selected to backup the transaction log for all databases. When you select that, it is going to try to do that. You cannot backup the transaction log for databases in the simple recovery model, as you see in the first part of the message. In the second part, you have a database where the compatibility level is set to 70 (SQL Server 7), and you cannot backup the transaction log for that database on a 2005 system. You need to change the compatibility level to 80 or 90.

Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources