SQL Setup Recomendation - Maintenance Plan Not Removing .bak files

#1

I am having the same problem on all 6 of our SQL servers with the backup job
not deleting .bak files after a certain amount of days. The Microsoft SQL
Backup job runs, but the files are not deleting, even though I have told it
to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next step
is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the process
stops working.

Thanks,

Tim

#2

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#3

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#4

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#5

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#6

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#7

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#8

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#9

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

#10

If you are sure that jobs run successfully (right click on the plans and see
their histories) then ensure that you type a correct file extension, which
is "bak" without the apostrophes. And ensure that you type a correct path
for the back up files which are supposed to be deleted after a period.

These are the common problems I see when someone complains about deleting
old backups using a maintenance plan.

--
Ekrem Önsoy

"Tim Shoemaker" <tims (AT) foo (DOT) fom> wrote

Quote:

I am having the same problem on all 6 of our SQL servers with the backup
job not deleting .bak files after a certain amount of days. The Microsoft
SQL Backup job runs, but the files are not deleting, even though I have
told it to.

I am running SQL 2000 and SQL 2005.

Does anyone have a good recomendation of a some SQL setup guides that I
could look through? I am convinced it has something to do with the SQL
Agent service and which user it is using to start the service. My next
step is to build a virtual invironment and see if it works on a default
installation, then make changes towards our current setup until the
process stops working.

Thanks,

Tim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Setup Recomendation - Maintenance Plan Not Removing .bak files

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 01:46 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM

Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bak files - 10-16-2008 , 03:05 PM