March 19, 2009 at 8:47 am
HI,
I created a maintenance plan to backup the sql log file and verify on an application database. When executing the job (created by the maintenance plan) it creates a .trn backup file but it doesn't create a corresponding .txt file showing the backup and verify steps worked.
On our SQl 2000 environment we run SQLMAINT.exe and it produces .txt file showing this information. See below. How can I get this same info running the maintenance plan in sql 2008?
Thanks
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SQLPROD004' as 'AIQ\sqlaccount' (trusted)
Starting maintenance of database 'dpUIS001' on 3/14/2009 4:00:01 PM
[1] Database dpUIS001: Transaction Log Backup...
Destination: [\\Sqlprod004\H\sqlProd004_SQLBackups\dpUIS001_tlog_200903141600.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database dpUIS001: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[nd of maintenance for database 'dpUIS001' on 3/14/2009 4:00:01 PM
SQLMAINT.EXE Process Exit Code: 0 (Success)
March 19, 2009 at 1:14 pm
You can go into the Maint. Plan
Note on the top toolbar (the one that says "Add Subplan" ..... ) there is a small icon right of "Manage Connections ..."
Click that and set where you want to store the reports
I have the FULL/DIFF/TLOG text file here no problem, stored in a separates \Reports folder
March 19, 2009 at 1:33 pm
Hi Jerry,
I tried your suggestion and it produces the report below basically only showing the main. plan succeeded. It doesn't tell me if the backup and verify steps succeeded or how long each step took to execute.
Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.1600
Report was generated on "RSTOLL-D1\RICHSQL2008".
Maintenance Plan: dpUIS001 Backup Trn Log
Duration: 00:00:03
Status: Succeeded.
Details:
Back Up Database Task (RSTOLL-D1\RICHSQL2008)
Task start: 2009-03-19T13:20:11.
Task end: 2009-03-19T13:20:15.
Success
March 19, 2009 at 2:16 pm
Mnn, did your Maint. Plan consist of multiple subplans? or it's one big task?
Mine are 1 Backup plan with 4 Subplans
FULL weekly
DIFF nightly
TLOG hourly
Cleanup
I get 4 text files (1 per each subplan) named like these (with full details inside)
Backup_FULL backup_20090315074706.txt
Backup_DIFF backup_20090319060518.txt
Backup_TLOG backup_20090319200056.txt
Backup_Cleanup_20090319100102.txt
March 19, 2009 at 2:22 pm
It's just 1 subplan. Can you paste what your report file looks like?
THanks
March 19, 2009 at 2:43 pm
Can't post too much for reasons, but I think I have found the cause for you
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042
Report was generated on "-------------".
Maintenance Plan: Backup
Duration: 00:00:54
Status: Warning: One or more tasks failed..
Details:
Back Up Database (Transaction Log) (-------------)
Backup Database on Local server connection
Databases: -------------------------
Type: Transaction Log
Append existing
Task start: 2009-03-19T20:00:03.
Task end: 2009-03-19T20:00:14.
----------a bunch of TSQL commands----------
Other logs are similar
Just try to use subplans and test
Good luck!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply