DBCC CHECKDB: maintanence

Showing posts with label maintanence. Show all posts

Friday, February 24, 2012

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...
>> 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?
>>
>|||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...
>> 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?
>>
>>
>|||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...
>> 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...
>> 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?
>>
>>
>>
>|||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...
> 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...
>> 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?
>>
>>
>|||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...
>> 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...
>> 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?
>>
>>
>>
>|||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...
> 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...
>> 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...
>> 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?
>>
>>
>>
>>
>|||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...
>> 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...
>> 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...
>> 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?
>>
>>
>>
>>
>>
>|||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...
>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...
>> 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...
>> 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...
>>> 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?
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||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...
>>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...
>> 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...
>> 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...
>>> 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?
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||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...
> 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...
>>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...
>> 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...
>>> 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...
>>> 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?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||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...
>> 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...
>>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...
>> 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...
>>> 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...
>>>> 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?
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Seems to be the Maint plan that want to verify that share. First thing I would do is to verify that
both Agent as well as SQL Server service account(s) has permission on the share. If they do, I'd
verify that this problem exist in a recent service pack/CU. If it still exists, it seems that Maint
plans in 2005 don't support removal of old backup files on a share.
--
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:uji14dIdIHA.4312@.TK2MSFTNGP03.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...
>> 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...
>>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...
>>> 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...
>>> 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...
>>>> 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?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

db maintanence plan failure

Hi all!
I have a DB Maintanence plan configured to run once a week that is supposed
to perform optimizations and integrity checks on all user databases. This is
split into 2 seperate jobs when I look at the Jobs node under SQL Agent. The
optimizations is set to run at 4 am & the integrity at 5 am. It appears that
the integrity check job keeps failing. The log says something about
'mosesdb' needs to be in single user mode. Any ideas? The optimization jobs
seems to complete OK
TIA!Param
Under Tab 'Integrity' uncheck 'Attempt to repair any minor problems'
SQL Server is trying to repair some problems but it requires database to be
in single user mode.
"Param R." <pr@.nospam.com> wrote in message
news:ed%23BifjEFHA.1012@.TK2MSFTNGP14.phx.gbl...
> Hi all!
> I have a DB Maintanence plan configured to run once a week that is
supposed
> to perform optimizations and integrity checks on all user databases. This
is
> split into 2 seperate jobs when I look at the Jobs node under SQL Agent.
The
> optimizations is set to run at 4 am & the integrity at 5 am. It appears
that
> the integrity check job keeps failing. The log says something about
> 'mosesdb' needs to be in single user mode. Any ideas? The optimization
jobs
> seems to complete OK
> TIA!
>|||OK. But wouldnt I want it to fix any problems? What is the best way then?
thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eSii%23klEFHA.2032@.tk2msftngp13.phx.gbl...
> Param
> Under Tab 'Integrity' uncheck 'Attempt to repair any minor problems'
> SQL Server is trying to repair some problems but it requires database to
> be
> in single user mode.
>
> "Param R." <pr@.nospam.com> wrote in message
> news:ed%23BifjEFHA.1012@.TK2MSFTNGP14.phx.gbl...
>> Hi all!
>> I have a DB Maintanence plan configured to run once a week that is
> supposed
>> to perform optimizations and integrity checks on all user databases. This
> is
>> split into 2 seperate jobs when I look at the Jobs node under SQL Agent.
> The
>> optimizations is set to run at 4 am & the integrity at 5 am. It appears
> that
>> the integrity check job keeps failing. The log says something about
>> 'mosesdb' needs to be in single user mode. Any ideas? The optimization
> jobs
>> seems to complete OK
>> TIA!
>>
>|||If my car keep breaking down, I'd like to know why that happen so I can avoid it keeping breaking
down when I travel at high speed. I.e., if you get such problem, you want to do root-cause analysis
why they happen. Often it is because hardware problems.
In other words, the option in maint wiz is IMO not well thought through, and AFAIK, it will be
removed in next version of SQL Server. The option, btw makes maint wiz execute DBCC CHECKDB using
the REPAIR_FAST option.
To be able to run DBCC CHECKDB with FAST_REPAIR, the database must be in single user mode, so if you
have users in the database, the command and subsequently job will fail.
Also, you might want to check out: http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Param R." <pr@.nospam.com> wrote in message news:%23Czx7SqEFHA.1188@.tk2msftngp13.phx.gbl...
> OK. But wouldnt I want it to fix any problems? What is the best way then?
> thanks!
> "Uri Dimant" <urid@.iscar.co.il> wrote in message news:eSii%23klEFHA.2032@.tk2msftngp13.phx.gbl...
>> Param
>> Under Tab 'Integrity' uncheck 'Attempt to repair any minor problems'
>> SQL Server is trying to repair some problems but it requires database to be
>> in single user mode.
>>
>> "Param R." <pr@.nospam.com> wrote in message
>> news:ed%23BifjEFHA.1012@.TK2MSFTNGP14.phx.gbl...
>> Hi all!
>> I have a DB Maintanence plan configured to run once a week that is
>> supposed
>> to perform optimizations and integrity checks on all user databases. This
>> is
>> split into 2 seperate jobs when I look at the Jobs node under SQL Agent.
>> The
>> optimizations is set to run at 4 am & the integrity at 5 am. It appears
>> that
>> the integrity check job keeps failing. The log says something about
>> 'mosesdb' needs to be in single user mode. Any ideas? The optimization
>> jobs
>> seems to complete OK
>> TIA!
>>
>>
>|||I agree I need to know what is causing the problem. But how can I find that
out? The database seems to appear functional from the application
perspective. How can I determine if it is corrupt and if so what is causing
it to be corrupt? The link below gives me some info, but not all.
thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e20IkmqEFHA.1264@.TK2MSFTNGP12.phx.gbl...
> If my car keep breaking down, I'd like to know why that happen so I can
> avoid it keeping breaking down when I travel at high speed. I.e., if you
> get such problem, you want to do root-cause analysis why they happen.
> Often it is because hardware problems.
> In other words, the option in maint wiz is IMO not well thought through,
> and AFAIK, it will be removed in next version of SQL Server. The option,
> btw makes maint wiz execute DBCC CHECKDB using the REPAIR_FAST option.
> To be able to run DBCC CHECKDB with FAST_REPAIR, the database must be in
> single user mode, so if you have users in the database, the command and
> subsequently job will fail.
> Also, you might want to check out:
> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Param R." <pr@.nospam.com> wrote in message
> news:%23Czx7SqEFHA.1188@.tk2msftngp13.phx.gbl...
>> OK. But wouldnt I want it to fix any problems? What is the best way then?
>> thanks!
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eSii%23klEFHA.2032@.tk2msftngp13.phx.gbl...
>> Param
>> Under Tab 'Integrity' uncheck 'Attempt to repair any minor problems'
>> SQL Server is trying to repair some problems but it requires database
>> to be
>> in single user mode.
>>
>> "Param R." <pr@.nospam.com> wrote in message
>> news:ed%23BifjEFHA.1012@.TK2MSFTNGP14.phx.gbl...
>> Hi all!
>> I have a DB Maintanence plan configured to run once a week that is
>> supposed
>> to perform optimizations and integrity checks on all user databases.
>> This
>> is
>> split into 2 seperate jobs when I look at the Jobs node under SQL
>> Agent.
>> The
>> optimizations is set to run at 4 am & the integrity at 5 am. It appears
>> that
>> the integrity check job keeps failing. The log says something about
>> 'mosesdb' needs to be in single user mode. Any ideas? The optimization
>> jobs
>> seems to complete OK
>> TIA!
>>
>>
>>
>|||Maint wiz has an option to create a report file for each execution. Here you will find the error
messages.
In your situation, the problem is most likely not corruption. The problem is that maint wiz is
trying to set the database in single user mode (because of that option is checked), and you have
users connected to the database. Uncheck the option, and that problem will go away.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Param R." <pr@.nospam.com> wrote in message news:u5DxcdrEFHA.2232@.TK2MSFTNGP14.phx.gbl...
>I agree I need to know what is causing the problem. But how can I find that out? The database seems
>to appear functional from the application perspective. How can I determine if it is corrupt and if
>so what is causing it to be corrupt? The link below gives me some info, but not all.
> thanks!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:e20IkmqEFHA.1264@.TK2MSFTNGP12.phx.gbl...
>> If my car keep breaking down, I'd like to know why that happen so I can avoid it keeping breaking
>> down when I travel at high speed. I.e., if you get such problem, you want to do root-cause
>> analysis why they happen. Often it is because hardware problems.
>> In other words, the option in maint wiz is IMO not well thought through, and AFAIK, it will be
>> removed in next version of SQL Server. The option, btw makes maint wiz execute DBCC CHECKDB using
>> the REPAIR_FAST option.
>> To be able to run DBCC CHECKDB with FAST_REPAIR, the database must be in single user mode, so if
>> you have users in the database, the command and subsequently job will fail.
>> Also, you might want to check out: http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Param R." <pr@.nospam.com> wrote in message news:%23Czx7SqEFHA.1188@.tk2msftngp13.phx.gbl...
>> OK. But wouldnt I want it to fix any problems? What is the best way then?
>> thanks!
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message news:eSii%23klEFHA.2032@.tk2msftngp13.phx.gbl...
>> Param
>> Under Tab 'Integrity' uncheck 'Attempt to repair any minor problems'
>> SQL Server is trying to repair some problems but it requires database to be
>> in single user mode.
>>
>> "Param R." <pr@.nospam.com> wrote in message
>> news:ed%23BifjEFHA.1012@.TK2MSFTNGP14.phx.gbl...
>> Hi all!
>> I have a DB Maintanence plan configured to run once a week that is
>> supposed
>> to perform optimizations and integrity checks on all user databases. This
>> is
>> split into 2 seperate jobs when I look at the Jobs node under SQL Agent.
>> The
>> optimizations is set to run at 4 am & the integrity at 5 am. It appears
>> that
>> the integrity check job keeps failing. The log says something about
>> 'mosesdb' needs to be in single user mode. Any ideas? The optimization
>> jobs
>> seems to complete OK
>> TIA!
>>
>>
>>
>>
>

Friday, February 24, 2012

db maintanence plan question

db maintanence plan question

db maintanence plan failure

db maintanence plan failure

Sunday, February 19, 2012

db maintanence plan failure

DBCC CHECKDB

Blog Archive

About Me