db maintanence plan question

On my databases I have a backup maintanence plan on all of them. The plan
also includes a clean of backups that are 4 days old. My backup is working
but the clean up portion is not. I'm backing up the .bak files to a file
server on the network, could that cause the clean up process not to work? If
so, what do I need to do to get the clean up step to remove all the .bak
files that are 4 days old from the file server? Is it even possible to do?
Does the account that is running the SQL Agent service have permissions to
delete files from that network resource?
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
news:OpVS657cIHA.5668@.TK2MSFTNGP05.phx.gbl...
> On my databases I have a backup maintanence plan on all of them. The plan
> also includes a clean of backups that are 4 days old. My backup is working
> but the clean up portion is not. I'm backing up the .bak files to a file
> server on the network, could that cause the clean up process not to work?
> If so, what do I need to do to get the clean up step to remove all the
> .bak files that are 4 days old from the file server? Is it even possible
> to do?
>
>
|||yes, all of databases are configured the same and this did work at one time.
We had the change the location to point to a new folder on the same server
and that folder has the same permissions as the folder did that this worked.
That's the only change and my SQL 2000 db's have no issues in doing this,
its only my SQL 05 servers.
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:eL8fQI8cIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Does the account that is running the SQL Agent service have permissions to
> delete files from that network resource?
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
> news:OpVS657cIHA.5668@.TK2MSFTNGP05.phx.gbl...
>
|||Any errors in the Maintenance Plan logs?
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
news:OhPUOO8cIHA.1960@.TK2MSFTNGP02.phx.gbl...
> yes, all of databases are configured the same and this did work at one
> time. We had the change the location to point to a new folder on the same
> server and that folder has the same permissions as the folder did that
> this worked.
> That's the only change and my SQL 2000 db's have no issues in doing this,
> its only my SQL 05 servers.
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:eL8fQI8cIHA.4476@.TK2MSFTNGP06.phx.gbl...
>
|||No, no errors in the log.
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:etPNVb8cIHA.536@.TK2MSFTNGP06.phx.gbl...
> Any errors in the Maintenance Plan logs?
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
> news:OhPUOO8cIHA.1960@.TK2MSFTNGP02.phx.gbl...
>
|||the backup plan is pointing to the new location. Where do I define the
location for the cleanup?
I just took this task over so I'm figuring out SQL 05 as I go. Everything
was already setup, I just had to point the backup plan to the new location.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Os%232tv8cIHA.1376@.TK2MSFTNGP02.phx.gbl...
> Did you modify the maintenance cleanup task to reflect the folder?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
> news:OhPUOO8cIHA.1960@.TK2MSFTNGP02.phx.gbl...
>
|||I have that and it points to SQL servers and when I try to add the location
for the BAK files it fails to connect.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUiuFR9cIHA.288@.TK2MSFTNGP02.phx.gbl...
> Edit the plan. You should see a task named "Maintenance Cleanup task".
> this is where you specify the location. If you don't have such a task, add
> it. You do *not* specify backup file removal inside the backup task in
> 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
> news:%23eAJZI9cIHA.5984@.TK2MSFTNGP06.phx.gbl...
>
|||I've done that, 4 times actually and I'm getting the same message when
trying to connect to the new location.
'unable to find sever DbbackUp'
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oyf1Ie9cIHA.1132@.TK2MSFTNGP06.phx.gbl...
> Seems it got messed up somehow. I'd remove the task and add a new one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
> news:%23rQGKd9cIHA.4436@.TK2MSFTNGP05.phx.gbl...
>
|||So far I removed the current plans, created a new db backup plan which
points to the location, then I created a seperate cleanup plan and when I
type in the UNC path, I get the error 'unable to find \\nas123\sqlbackups\'
and this is only happening on my SQL 2005 Servers not my SQL 2000 servers.
The SQL 2000 servers are backing up and deleting bak files that are older
then 5 days, the SQL 05 servers - nothing.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OmQ3yDIdIHA.4196@.TK2MSFTNGP04.phx.gbl...
> Where is the failure? The connection (top of that dialog) or the location
> for the folder? If the folder, then I suggest you use an UNC path and type
> the path (not browse).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mike" <Mike@.aseagullpoopedonmyhead.com> wrote in message
> news:ODR8bo9cIHA.5208@.TK2MSFTNGP04.phx.gbl...
>