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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2009-01-28 : 20:30:16
|
| The past few days we've seen some issues with memory jumping on our SQL 2005 Standard box. All my daily jobs showed no errors running so I never thought to double check the results. When I went to look at my backup transaction log folder I found no logs for the past day. I then went to look at the maintenance plan and found all the check boxes unchecked for the specific database I wanted to have backed up e.g. the transaction logs. Now is it possible for this to change and is there any record kept in the database when you alter a maintenance plan?thanks |
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2009-01-28 : 21:29:56
|
| What SP are you running. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-28 : 23:29:26
|
quote:
Originally posted by bogey
The past few days we've seen some issues with memory jumping on our SQL 2005 Standard box. All my daily jobs showed no errors running so I never thought to double check the results. When I went to look at my backup transaction log folder I found no logs for the past day. I then went to look at the maintenance plan and found all the check boxes unchecked for the specific database I wanted to have backed up e.g. the transaction logs. Now is it possible for this to change and is there any record kept in the database when you alter a maintenance plan?thanks
Yes it is stored in dbo.sysmaintplan_plans |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-01-29 : 02:15:36
|
| Tara would u like to share complete list showing NOT TO USE MAINTINANCE PLANcan i find it out in ur blog ? |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2009-01-29 : 08:19:15
|
quote:
Originally posted by acollins74
What SP are you running.
Verstion 9.0.3068 |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2009-01-29 : 08:29:43
|
quote:
Originally posted by sodeep
quote:
Originally posted by bogey
The past few days we've seen some issues with memory jumping on our SQL 2005 Standard box. All my daily jobs showed no errors running so I never thought to double check the results. When I went to look at my backup transaction log folder I found no logs for the past day. I then went to look at the maintenance plan and found all the check boxes unchecked for the specific database I wanted to have backed up e.g. the transaction logs. Now is it possible for this to change and is there any record kept in the database when you alter a maintenance plan?thanks
Yes it is stored in dbo.sysmaintplan_plans
There is no alter date in this table just create date |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-01-29 : 16:44:13
|
| Did you also update the 2005 client software SP on the computers you are using to modify maintenence plans?There were some issues with maint plans in 2005 SP2 that caused them to reissue a new SP2 a few days after the original release.CODO ERGO SUM |
|
|
|
|
|
|
Possible for Maintenance Plan to Alter Self ??