Backup job failed-SVP2

I have a job that has run fine for quite a while now. It backs up db and
trans logs file and then deletes bak and log files older than 2 days. I
noticed that since 4/23/07, it hadn't deleted the bak files nor the trans
log files either. I also remembered putting SVP2 on it about that time.
I'm running SS2005 on Server 2003. The job has 4 'nodes' Back Up Databse
(full)/ Back Up Databse Trans log/databse cleanup/trans log cleanup. I
noticed that the backup jobs connection says, "Target Server Connection" but
the "maintenance" jobs (the ones that delete the old bak and trans log files
that is bombing) was run as "SACONNECT". Does anyone know why that would
have changed with SVP2? Honestly, I'm not sure what it was prior to SVP2
going in.
What IS the difference between "Target server connection", "SACONNECT", and
"Local server connection"? I just want the one that has the ability to
delete older files in the backup folders.
You didn't mention if there are any errors or what's in the
history for the maintenance plan but this could be related
to some known issues with SP2. The issues are related to the
clean up tasks.
You should still check for logs for errors when the
maintenance plan runs. And then you should try to figure out
what version of SP2 you are running on the server as well as
your client side and see if you are affected by the issues
with SP2. See the following article:
Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup
tasks run at different intervals than intended
http://support.microsoft.com/kb/933508
-Sue
On Mon, 7 May 2007 10:06:40 -0400, "Peter Lux"
<pete.lux@.theheritagegrp.com> wrote:

>I have a job that has run fine for quite a while now. It backs up db and
>trans logs file and then deletes bak and log files older than 2 days. I
>noticed that since 4/23/07, it hadn't deleted the bak files nor the trans
>log files either. I also remembered putting SVP2 on it about that time.
>I'm running SS2005 on Server 2003. The job has 4 'nodes' Back Up Databse
>(full)/ Back Up Databse Trans log/databse cleanup/trans log cleanup. I
>noticed that the backup jobs connection says, "Target Server Connection" but
>the "maintenance" jobs (the ones that delete the old bak and trans log files
>that is bombing) was run as "SACONNECT". Does anyone know why that would
>have changed with SVP2? Honestly, I'm not sure what it was prior to SVP2
>going in.
>What IS the difference between "Target server connection", "SACONNECT", and
>"Local server connection"? I just want the one that has the ability to
>delete older files in the backup folders.
>
|||Hi Peter,
Could you please mail me (changliw_at_microsoft_dot_com) the SQL error logs
for further research?
By default, the error logs were in the folder: %ProgramFiles%\Microsoft SQL
Server\MSSQL\LOG.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:vvlQF1RkHHA.1144@.TK2MSFTNGHUB02.phx.gbl...
> Hi Peter,
> Could you please mail me (changliw_at_microsoft_dot_com) the SQL error
> logs
> for further research?
Charles.. I sent it.
|||Hi Pete,
Thanks for your email response.
After looked through the error logs, I found that your database back files
were stored separately in the subdirectories of MSSQLBackups. I am afraid
that that is the trick.Maintenance tasks in SQL Server 2005 cannot delete
subdirectories. I recommend that you create a separate Maintenance cleanup
for each database.
For more information, please refer to:
Back up Database Task (Maintenance Plan)
http://msdn2.microsoft.com/en-us/library/ms189647.aspx
( refer to the section Create a sub-directory for each database).
If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||SP1 fixed the subfolder delete issue. After applying SP1,
there is a checkbox on the Maintenance Cleanup Task called
"Include first-level subfolders". You select that to delete
files in subfolders. However, You can't configure it using
the wizard. You have to create the Maintenance Plan and then
go back and modify the Maintenance Cleanup Task afterward.
-Sue
On Wed, 09 May 2007 07:19:38 GMT,
changliw@.online.microsoft.com (Charles Wang[MSFT]) wrote:

>Hi Pete,
>Thanks for your email response.
>After looked through the error logs, I found that your database back files
>were stored separately in the subdirectories of MSSQLBackups. I am afraid
>that that is the trick.Maintenance tasks in SQL Server 2005 cannot delete
>subdirectories. I recommend that you create a separate Maintenance cleanup
>for each database.
>For more information, please refer to:
>Back up Database Task (Maintenance Plan)
>http://msdn2.microsoft.com/en-us/library/ms189647.aspx
>( refer to the section Create a sub-directory for each database).
>If you have any other questions or concerns, please feel free to let me
>know. It is my pleasure to be of assistance.
>Best regards,
>Charles Wang
>Microsoft Online Community Support
>================================================= ====
>Get notification to my posts through email? Please refer to:
>http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>ications
>If you are using Outlook Express, please make sure you clear the check box
>"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
>
>Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
>where an initial response from the community or a Microsoft Support
>Engineer within 1 business day is acceptable. Please note that each follow
>up response may take approximately 2 business days as the support
>professional working with you may need further investigation to reach the
>most efficient resolution. The offering is not appropriate for situations
>that require urgent, real-time or phone-based interactions or complex
>project analysis and dump analysis issues. Issues of this nature are best
>handled working with a dedicated Microsoft Support Engineer by contacting
>Microsoft Customer Support Services (CSS) at
>http://msdn.microsoft.com/subscriptions/support/default.aspx.
>================================================= =====
>When responding to posts, please "Reply to Group" via
>your newsreader so that others may learn and benefit
>from this issue.
>================================================= =====
>This posting is provided "AS IS" with no warranties, and confers no rights.
>================================================= =====
>
|||Hi Sue,
Thanks for your pointing out. I am sorry that I missed that since I checked
a SQL Server 2005 instance with no SP1.
Pete, could you please check the content of the File Extention? The correct
conent should be like ".trn;.bak". Please check if the dot was missed.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====