|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Maintenance did not delete old files
HI All,
[SQL 2005 Standard Edition with SP3] I have a problem with maintenance plan that created on SQL server 2005 to take a full backup then delete old files that older than 10 hours. it is running well on taking the backup file, but it does not delete old backup files, I reviewed the folder security and make sure that the SQL Agent user has full control on that folder. Q: why old files did not deleted ? -- Mahmoud Amin Yes, I can reproduce it, looks like a bug
<m_ami***@hotmail.com> wrote in message Show quoteHide quote news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... > HI All, > > [SQL 2005 Standard Edition with SP3] > > I have a problem with maintenance plan that created on SQL server 2005 to > take a full backup then delete old files that older than 10 hours. > it is running well on taking the backup file, but it does not delete old > backup files, I reviewed the folder security and make sure that the SQL > Agent user has full control on that folder. > > Q: why old files did not deleted ? > > -- > Mahmoud Amin > > > > How did you configure the MP to delete old backup files? Did you use a
Maintenance Cleanup Task? -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi <m_ami***@hotmail.com> wrote in message news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... > HI All, > > [SQL 2005 Standard Edition with SP3] > > I have a problem with maintenance plan that created on SQL server > 2005 to take a full backup then delete old files that older than 10 > hours. > it is running well on taking the backup file, but it does not delete > old backup files, I reviewed the folder security and make sure that > the SQL Agent user has full control on that folder. > > Q: why old files did not deleted ? > > -- > Mahmoud Amin > > > > Yes, I use Maintenance Cleanup task.
-- Show quoteHide quoteMahmoud Amin "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... > How did you configure the MP to delete old backup files? Did you use a > Maintenance Cleanup Task? > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > <m_ami***@hotmail.com> wrote in message > news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >> HI All, >> >> [SQL 2005 Standard Edition with SP3] >> >> I have a problem with maintenance plan that created on SQL server 2005 to >> take a full backup then delete old files that older than 10 hours. >> it is running well on taking the backup file, but it does not delete old >> backup files, I reviewed the folder security and make sure that the SQL >> Agent user has full control on that folder. >> >> Q: why old files did not deleted ? >> >> -- >> Mahmoud Amin >> >> >> >> > Did you specify for the backup to create the backup in a subfolder? If
so, did you specify for the cleanup task to recurse subfolders? Correct path? Right file extension? -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi <m_ami***@hotmail.com> wrote in message news:9551331B-9217-47BD-A6DF-F9DA1795B42C@microsoft.com... > Yes, I use Maintenance Cleanup task. > > -- > Mahmoud Amin > > > > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> > wrote in message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... >> How did you configure the MP to delete old backup files? Did you >> use a Maintenance Cleanup Task? >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> <m_ami***@hotmail.com> wrote in message >> news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >>> HI All, >>> >>> [SQL 2005 Standard Edition with SP3] >>> >>> I have a problem with maintenance plan that created on SQL server >>> 2005 to take a full backup then delete old files that older than >>> 10 hours. >>> it is running well on taking the backup file, but it does not >>> delete old backup files, I reviewed the folder security and make >>> sure that the SQL Agent user has full control on that folder. >>> >>> Q: why old files did not deleted ? >>> >>> -- >>> Mahmoud Amin >>> >>> >>> >>> >> Hi Tibor,
Yes, I did the maintenance plan in a well design, the same maintenance plan on another PC running well on developer edition but not on standard edition. the two edition have SP3. -- Show quoteHide quoteMahmoud Amin "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:u8hs#PM#JHA.4168@TK2MSFTNGP05.phx.gbl... > Did you specify for the backup to create the backup in a subfolder? If so, > did you specify for the cleanup task to recurse subfolders? Correct path? > Right file extension? > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > <m_ami***@hotmail.com> wrote in message > news:9551331B-9217-47BD-A6DF-F9DA1795B42C@microsoft.com... >> Yes, I use Maintenance Cleanup task. >> >> -- >> Mahmoud Amin >> >> >> >> >> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote >> in message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... >>> How did you configure the MP to delete old backup files? Did you use a >>> Maintenance Cleanup Task? >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://sqlblog.com/blogs/tibor_karaszi >>> >>> >>> <m_ami***@hotmail.com> wrote in message >>> news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >>>> HI All, >>>> >>>> [SQL 2005 Standard Edition with SP3] >>>> >>>> I have a problem with maintenance plan that created on SQL server 2005 >>>> to take a full backup then delete old files that older than 10 hours. >>>> it is running well on taking the backup file, but it does not delete >>>> old backup files, I reviewed the folder security and make sure that the >>>> SQL Agent user has full control on that folder. >>>> >>>> Q: why old files did not deleted ? >>>> >>>> -- >>>> Mahmoud Amin >>>> >>>> >>>> >>>> >>> > And the service account for the SQL Server service (not agent) has
appropriate permissions? Any errors in the report file? Maint history tables (as accessible by right-clicking the maint plan)? -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi <m_ami***@hotmail.com> wrote in message news:44716D8B-45F6-4FC2-953C-1E7942040D21@microsoft.com... > Hi Tibor, > > Yes, I did the maintenance plan in a well design, the same > maintenance plan on another PC running well on developer edition but > not on standard edition. > the two edition have SP3. > > -- > Mahmoud Amin > > > > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> > wrote in message news:u8hs#PM#JHA.4168@TK2MSFTNGP05.phx.gbl... >> Did you specify for the backup to create the backup in a subfolder? >> If so, did you specify for the cleanup task to recurse subfolders? >> Correct path? Right file extension? >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> <m_ami***@hotmail.com> wrote in message >> news:9551331B-9217-47BD-A6DF-F9DA1795B42C@microsoft.com... >>> Yes, I use Maintenance Cleanup task. >>> >>> -- >>> Mahmoud Amin >>> >>> >>> >>> >>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>> wrote in message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... >>>> How did you configure the MP to delete old backup files? Did you >>>> use a Maintenance Cleanup Task? >>>> >>>> -- >>>> Tibor Karaszi, SQL Server MVP >>>> http://www.karaszi.com/sqlserver/default.asp >>>> http://sqlblog.com/blogs/tibor_karaszi >>>> >>>> >>>> <m_ami***@hotmail.com> wrote in message >>>> news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >>>>> HI All, >>>>> >>>>> [SQL 2005 Standard Edition with SP3] >>>>> >>>>> I have a problem with maintenance plan that created on SQL >>>>> server 2005 to take a full backup then delete old files that >>>>> older than 10 hours. >>>>> it is running well on taking the backup file, but it does not >>>>> delete old backup files, I reviewed the folder security and make >>>>> sure that the SQL Agent user has full control on that folder. >>>>> >>>>> Q: why old files did not deleted ? >>>>> >>>>> -- >>>>> Mahmoud Amin >>>>> >>>>> >>>>> >>>>> >>>> >> The SQL Server Service (not agent) is running by administrator account that
already has full permission. There is NO error in the maint history, (Successful) -- Show quoteHide quoteMahmoud Amin "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:urYSVzU#JHA.4360@TK2MSFTNGP04.phx.gbl... > And the service account for the SQL Server service (not agent) has > appropriate permissions? Any errors in the report file? Maint history > tables (as accessible by right-clicking the maint plan)? > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > <m_ami***@hotmail.com> wrote in message > news:44716D8B-45F6-4FC2-953C-1E7942040D21@microsoft.com... >> Hi Tibor, >> >> Yes, I did the maintenance plan in a well design, the same maintenance >> plan on another PC running well on developer edition but not on standard >> edition. >> the two edition have SP3. >> >> -- >> Mahmoud Amin >> >> >> >> >> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote >> in message news:u8hs#PM#JHA.4168@TK2MSFTNGP05.phx.gbl... >>> Did you specify for the backup to create the backup in a subfolder? If >>> so, did you specify for the cleanup task to recurse subfolders? Correct >>> path? Right file extension? >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://sqlblog.com/blogs/tibor_karaszi >>> >>> >>> <m_ami***@hotmail.com> wrote in message >>> news:9551331B-9217-47BD-A6DF-F9DA1795B42C@microsoft.com... >>>> Yes, I use Maintenance Cleanup task. >>>> >>>> -- >>>> Mahmoud Amin >>>> >>>> >>>> >>>> >>>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>>> wrote in message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... >>>>> How did you configure the MP to delete old backup files? Did you use a >>>>> Maintenance Cleanup Task? >>>>> >>>>> -- >>>>> Tibor Karaszi, SQL Server MVP >>>>> http://www.karaszi.com/sqlserver/default.asp >>>>> http://sqlblog.com/blogs/tibor_karaszi >>>>> >>>>> >>>>> <m_ami***@hotmail.com> wrote in message >>>>> news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >>>>>> HI All, >>>>>> >>>>>> [SQL 2005 Standard Edition with SP3] >>>>>> >>>>>> I have a problem with maintenance plan that created on SQL server >>>>>> 2005 to take a full backup then delete old files that older than 10 >>>>>> hours. >>>>>> it is running well on taking the backup file, but it does not delete >>>>>> old backup files, I reviewed the folder security and make sure that >>>>>> the SQL Agent user has full control on that folder. >>>>>> >>>>>> Q: why old files did not deleted ? >>>>>> >>>>>> -- >>>>>> Mahmoud Amin >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>> > I'm sorry, but I'm out of ideas. The last thing I'd triple check is
the configuration regarding recurs subfolders, paths etc. And also compare to a working install whether it is sensitive to ending backslash in path name, dot before the file extension etc. I guess you also could run a Profiler trace when the job is running to capture the xp it is execution and try to compare that against a working install to see if you can spot the difference. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi <m_ami***@hotmail.com> wrote in message news:B207FFD1-E926-4A74-BE55-F9FE9E50A76C@microsoft.com... > The SQL Server Service (not agent) is running by administrator > account that already has full permission. > > There is NO error in the maint history, (Successful) > > -- > Mahmoud Amin > > > > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> > wrote in message news:urYSVzU#JHA.4360@TK2MSFTNGP04.phx.gbl... >> And the service account for the SQL Server service (not agent) has >> appropriate permissions? Any errors in the report file? Maint >> history tables (as accessible by right-clicking the maint plan)? >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> <m_ami***@hotmail.com> wrote in message >> news:44716D8B-45F6-4FC2-953C-1E7942040D21@microsoft.com... >>> Hi Tibor, >>> >>> Yes, I did the maintenance plan in a well design, the same >>> maintenance plan on another PC running well on developer edition >>> but not on standard edition. >>> the two edition have SP3. >>> >>> -- >>> Mahmoud Amin >>> >>> >>> >>> >>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>> wrote in message news:u8hs#PM#JHA.4168@TK2MSFTNGP05.phx.gbl... >>>> Did you specify for the backup to create the backup in a >>>> subfolder? If so, did you specify for the cleanup task to recurse >>>> subfolders? Correct path? Right file extension? >>>> >>>> -- >>>> Tibor Karaszi, SQL Server MVP >>>> http://www.karaszi.com/sqlserver/default.asp >>>> http://sqlblog.com/blogs/tibor_karaszi >>>> >>>> >>>> <m_ami***@hotmail.com> wrote in message >>>> news:9551331B-9217-47BD-A6DF-F9DA1795B42C@microsoft.com... >>>>> Yes, I use Maintenance Cleanup task. >>>>> >>>>> -- >>>>> Mahmoud Amin >>>>> >>>>> >>>>> >>>>> >>>>> "Tibor Karaszi" >>>>> <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in >>>>> message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... >>>>>> How did you configure the MP to delete old backup files? Did >>>>>> you use a Maintenance Cleanup Task? >>>>>> >>>>>> -- >>>>>> Tibor Karaszi, SQL Server MVP >>>>>> http://www.karaszi.com/sqlserver/default.asp >>>>>> http://sqlblog.com/blogs/tibor_karaszi >>>>>> >>>>>> >>>>>> <m_ami***@hotmail.com> wrote in message >>>>>> news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >>>>>>> HI All, >>>>>>> >>>>>>> [SQL 2005 Standard Edition with SP3] >>>>>>> >>>>>>> I have a problem with maintenance plan that created on SQL >>>>>>> server 2005 to take a full backup then delete old files that >>>>>>> older than 10 hours. >>>>>>> it is running well on taking the backup file, but it does not >>>>>>> delete old backup files, I reviewed the folder security and >>>>>>> make sure that the SQL Agent user has full control on that >>>>>>> folder. >>>>>>> >>>>>>> Q: why old files did not deleted ? >>>>>>> >>>>>>> -- >>>>>>> Mahmoud Amin >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>> >> What is the extension you put in the maintenance plan? If you put .bak or
..trn, or .anything it will search for files in the specified directory with <filename>..bak. Could that be the problem? Show quoteHide quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:uRDXApV#JHA.2824@TK2MSFTNGP03.phx.gbl... > I'm sorry, but I'm out of ideas. The last thing I'd triple check is the > configuration regarding recurs subfolders, paths etc. And also compare to > a working install whether it is sensitive to ending backslash in path > name, dot before the file extension etc. I guess you also could run a > Profiler trace when the job is running to capture the xp it is execution > and try to compare that against a working install to see if you can spot > the difference. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > <m_ami***@hotmail.com> wrote in message > news:B207FFD1-E926-4A74-BE55-F9FE9E50A76C@microsoft.com... >> The SQL Server Service (not agent) is running by administrator account >> that already has full permission. >> >> There is NO error in the maint history, (Successful) >> >> -- >> Mahmoud Amin >> >> >> >> >> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote >> in message news:urYSVzU#JHA.4360@TK2MSFTNGP04.phx.gbl... >>> And the service account for the SQL Server service (not agent) has >>> appropriate permissions? Any errors in the report file? Maint history >>> tables (as accessible by right-clicking the maint plan)? >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://sqlblog.com/blogs/tibor_karaszi >>> >>> >>> <m_ami***@hotmail.com> wrote in message >>> news:44716D8B-45F6-4FC2-953C-1E7942040D21@microsoft.com... >>>> Hi Tibor, >>>> >>>> Yes, I did the maintenance plan in a well design, the same maintenance >>>> plan on another PC running well on developer edition but not on >>>> standard edition. >>>> the two edition have SP3. >>>> >>>> -- >>>> Mahmoud Amin >>>> >>>> >>>> >>>> >>>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>>> wrote in message news:u8hs#PM#JHA.4168@TK2MSFTNGP05.phx.gbl... >>>>> Did you specify for the backup to create the backup in a subfolder? If >>>>> so, did you specify for the cleanup task to recurse subfolders? >>>>> Correct path? Right file extension? >>>>> >>>>> -- >>>>> Tibor Karaszi, SQL Server MVP >>>>> http://www.karaszi.com/sqlserver/default.asp >>>>> http://sqlblog.com/blogs/tibor_karaszi >>>>> >>>>> >>>>> <m_ami***@hotmail.com> wrote in message >>>>> news:9551331B-9217-47BD-A6DF-F9DA1795B42C@microsoft.com... >>>>>> Yes, I use Maintenance Cleanup task. >>>>>> >>>>>> -- >>>>>> Mahmoud Amin >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>>>>> wrote in message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... >>>>>>> How did you configure the MP to delete old backup files? Did you use >>>>>>> a Maintenance Cleanup Task? >>>>>>> >>>>>>> -- >>>>>>> Tibor Karaszi, SQL Server MVP >>>>>>> http://www.karaszi.com/sqlserver/default.asp >>>>>>> http://sqlblog.com/blogs/tibor_karaszi >>>>>>> >>>>>>> >>>>>>> <m_ami***@hotmail.com> wrote in message >>>>>>> news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >>>>>>>> HI All, >>>>>>>> >>>>>>>> [SQL 2005 Standard Edition with SP3] >>>>>>>> >>>>>>>> I have a problem with maintenance plan that created on SQL server >>>>>>>> 2005 to take a full backup then delete old files that older than 10 >>>>>>>> hours. >>>>>>>> it is running well on taking the backup file, but it does not >>>>>>>> delete old backup files, I reviewed the folder security and make >>>>>>>> sure that the SQL Agent user has full control on that folder. >>>>>>>> >>>>>>>> Q: why old files did not deleted ? >>>>>>>> >>>>>>>> -- >>>>>>>> Mahmoud Amin >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>> >>> > No it does not,
I use "bak" or "trn" without dot -- Show quoteHide quoteMahmoud Amin "Jeffrey Williams" <jeff.williams3***@verizon.net> wrote in message news:elpNt5e#JHA.1376@TK2MSFTNGP02.phx.gbl... > What is the extension you put in the maintenance plan? If you put .bak or > .trn, or .anything it will search for files in the specified directory > with <filename>..bak. Could that be the problem? > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote > in message news:uRDXApV#JHA.2824@TK2MSFTNGP03.phx.gbl... >> I'm sorry, but I'm out of ideas. The last thing I'd triple check is the >> configuration regarding recurs subfolders, paths etc. And also compare to >> a working install whether it is sensitive to ending backslash in path >> name, dot before the file extension etc. I guess you also could run a >> Profiler trace when the job is running to capture the xp it is execution >> and try to compare that against a working install to see if you can spot >> the difference. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> <m_ami***@hotmail.com> wrote in message >> news:B207FFD1-E926-4A74-BE55-F9FE9E50A76C@microsoft.com... >>> The SQL Server Service (not agent) is running by administrator account >>> that already has full permission. >>> >>> There is NO error in the maint history, (Successful) >>> >>> -- >>> Mahmoud Amin >>> >>> >>> >>> >>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote >>> in message news:urYSVzU#JHA.4360@TK2MSFTNGP04.phx.gbl... >>>> And the service account for the SQL Server service (not agent) has >>>> appropriate permissions? Any errors in the report file? Maint history >>>> tables (as accessible by right-clicking the maint plan)? >>>> >>>> -- >>>> Tibor Karaszi, SQL Server MVP >>>> http://www.karaszi.com/sqlserver/default.asp >>>> http://sqlblog.com/blogs/tibor_karaszi >>>> >>>> >>>> <m_ami***@hotmail.com> wrote in message >>>> news:44716D8B-45F6-4FC2-953C-1E7942040D21@microsoft.com... >>>>> Hi Tibor, >>>>> >>>>> Yes, I did the maintenance plan in a well design, the same maintenance >>>>> plan on another PC running well on developer edition but not on >>>>> standard edition. >>>>> the two edition have SP3. >>>>> >>>>> -- >>>>> Mahmoud Amin >>>>> >>>>> >>>>> >>>>> >>>>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>>>> wrote in message news:u8hs#PM#JHA.4168@TK2MSFTNGP05.phx.gbl... >>>>>> Did you specify for the backup to create the backup in a subfolder? >>>>>> If so, did you specify for the cleanup task to recurse subfolders? >>>>>> Correct path? Right file extension? >>>>>> >>>>>> -- >>>>>> Tibor Karaszi, SQL Server MVP >>>>>> http://www.karaszi.com/sqlserver/default.asp >>>>>> http://sqlblog.com/blogs/tibor_karaszi >>>>>> >>>>>> >>>>>> <m_ami***@hotmail.com> wrote in message >>>>>> news:9551331B-9217-47BD-A6DF-F9DA1795B42C@microsoft.com... >>>>>>> Yes, I use Maintenance Cleanup task. >>>>>>> >>>>>>> -- >>>>>>> Mahmoud Amin >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>>>>>> wrote in message news:OqQTX1K#JHA.3768@TK2MSFTNGP04.phx.gbl... >>>>>>>> How did you configure the MP to delete old backup files? Did you >>>>>>>> use a Maintenance Cleanup Task? >>>>>>>> >>>>>>>> -- >>>>>>>> Tibor Karaszi, SQL Server MVP >>>>>>>> http://www.karaszi.com/sqlserver/default.asp >>>>>>>> http://sqlblog.com/blogs/tibor_karaszi >>>>>>>> >>>>>>>> >>>>>>>> <m_ami***@hotmail.com> wrote in message >>>>>>>> news:0CC51184-F9FA-4128-9611-53D142A1F177@microsoft.com... >>>>>>>>> HI All, >>>>>>>>> >>>>>>>>> [SQL 2005 Standard Edition with SP3] >>>>>>>>> >>>>>>>>> I have a problem with maintenance plan that created on SQL server >>>>>>>>> 2005 to take a full backup then delete old files that older than >>>>>>>>> 10 hours. >>>>>>>>> it is running well on taking the backup file, but it does not >>>>>>>>> delete old backup files, I reviewed the folder security and make >>>>>>>>> sure that the SQL Agent user has full control on that folder. >>>>>>>>> >>>>>>>>> Q: why old files did not deleted ? >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Mahmoud Amin >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>> >>>> >>  
Other interesting topics
How to Enqueue Messages With Service Broker in a Timely Fashion
Activity Monitor not showing Database names Server2000 Std Edition Timeouts stats_ver_current? Unable to access the tape for database backup purpose share Template location for SSMS dbcc checkdb fix Modifying table issue using profiler to capture errors Missing Index Details |
|||||||||||||||||||||||
