|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Backup job failed-SVP2I 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.***@theheritagegrp.com> wrote: Show quote >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]" <chang***@online.microsoft.com> wrote in message Charles.. I sent it.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? 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, chang***@online.microsoft.com (Charles Wang[MSFT]) wrote: Show quote >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. ======================================================  |
|||||||||||||||||||||||
Other interesting topics