db_backupoperator question

I have assigned an user id to a role of db_backupoperator. But after I
created a scheduled job to do backup weekly, it won't run at all. No error
message in the event application. So I go to do the backup manually. I get
an error message when I click the "..." button to specify the backup file
location as following:
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Error 229: Execute permission denied on object 'xp_availablemedia',
database 'master', owner 'dbo'."
Please help. Thanks.
Hi,
Its seems your login account does not have the permissions required to
create a backup
device in hard disk. Please consult your system administrator or database
administrator
to obtain the required permissions to write in to the hard disk (Write
permission on the folder you craete the backup file).
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> I have assigned an user id to a role of db_backupoperator. But after I
> created a scheduled job to do backup weekly, it won't run at all. No error
> message in the event application. So I go to do the backup manually. I
get
> an error message when I click the "..." button to specify the backup file
> location as following:
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Error 229: Execute permission denied on object 'xp_availablemedia',
> database 'master', owner 'dbo'."
> Please help. Thanks.
>
|||Thanks, Hari. I have created the user id previously and didn't assign a
local win 2k user id to it. May be this is the problem. Now I just created
a local win 2k user id with the access right. But I don't want to delete the
sql user id and re-create it again? How can I map the current sql 2k user id
with the local win 2k user? Please let me know. Thanks.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> Its seems your login account does not have the permissions required to
> create a backup
> device in hard disk. Please consult your system administrator or database
> administrator
> to obtain the required permissions to write in to the hard disk (Write
> permission on the folder you craete the backup file).
> Thanks
> Hari
> MCDBA
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
error[vbcol=seagreen]
> get
file
>
|||Hi,
The user in which you start the SQL Server and SQL Agent service should have
the permission.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> Thanks, Hari. I have created the user id previously and didn't assign a
> local win 2k user id to it. May be this is the problem. Now I just
created
> a local win 2k user id with the access right. But I don't want to delete
the
> sql user id and re-create it again? How can I map the current sql 2k user
id[vbcol=seagreen]
> with the local win 2k user? Please let me know. Thanks.
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
database[vbcol=seagreen]
> error
I
> file
>
|||Hari,
I found out that both services are started with local system
accounts. Does that mean whoever shut down and re-start the service is the
local system accounts? Or it mean something else? Do I need to re-start both
services with the user id I used to do backup?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23601RbaMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hi,
> The user in which you start the SQL Server and SQL Agent service should
have[vbcol=seagreen]
> the permission.
> Thanks
> Hari
> MCDBA
>
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> created
> the
user[vbcol=seagreen]
> id
> database
I[vbcol=seagreen]
manually.
> I
>

db_backupoperator question

I have assigned an user id to a role of db_backupoperator. But after I
created a scheduled job to do backup weekly, it won't run at all. No error
message in the event application. So I go to do the backup manually. I get
an error message when I click the "..." button to specify the backup file
location as following:
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Error 229: Execute permission denied on object 'xp_availablemedia',
database 'master', owner 'dbo'."
Please help. Thanks.Hi,
Its seems your login account does not have the permissions required to
create a backup
device in hard disk. Please consult your system administrator or database
administrator
to obtain the required permissions to write in to the hard disk (Write
permission on the folder you craete the backup file).
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> I have assigned an user id to a role of db_backupoperator. But after I
> created a scheduled job to do backup weekly, it won't run at all. No error
> message in the event application. So I go to do the backup manually. I
get
> an error message when I click the "..." button to specify the backup file
> location as following:
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Error 229: Execute permission denied on object 'xp_availablemedia',
> database 'master', owner 'dbo'."
> Please help. Thanks.
>|||Thanks, Hari. I have created the user id previously and didn't assign a
local win 2k user id to it. May be this is the problem. Now I just created
a local win 2k user id with the access right. But I don't want to delete the
sql user id and re-create it again? How can I map the current sql 2k user id
with the local win 2k user? Please let me know. Thanks.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
> Hi,
> Its seems your login account does not have the permissions required to
> create a backup
> device in hard disk. Please consult your system administrator or database
> administrator
> to obtain the required permissions to write in to the hard disk (Write
> permission on the folder you craete the backup file).
> Thanks
> Hari
> MCDBA
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> > I have assigned an user id to a role of db_backupoperator. But after I
> > created a scheduled job to do backup weekly, it won't run at all. No
error
> > message in the event application. So I go to do the backup manually. I
> get
> > an error message when I click the "..." button to specify the backup
file
> > location as following:
> >
> > Microsoft SQL-DMO (ODBC SQLState: 42000)
> >
> > "Error 229: Execute permission denied on object 'xp_availablemedia',
> > database 'master', owner 'dbo'."
> >
> > Please help. Thanks.
> >
> >
>|||Hi,
The user in which you start the SQL Server and SQL Agent service should have
the permission.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> Thanks, Hari. I have created the user id previously and didn't assign a
> local win 2k user id to it. May be this is the problem. Now I just
created
> a local win 2k user id with the access right. But I don't want to delete
the
> sql user id and re-create it again? How can I map the current sql 2k user
id
> with the local win 2k user? Please let me know. Thanks.
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Its seems your login account does not have the permissions required to
> > create a backup
> > device in hard disk. Please consult your system administrator or
database
> > administrator
> > to obtain the required permissions to write in to the hard disk (Write
> > permission on the folder you craete the backup file).
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Eric Clapton" <no_spam@.bk.com> wrote in message
> > news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> > > I have assigned an user id to a role of db_backupoperator. But after I
> > > created a scheduled job to do backup weekly, it won't run at all. No
> error
> > > message in the event application. So I go to do the backup manually.
I
> > get
> > > an error message when I click the "..." button to specify the backup
> file
> > > location as following:
> > >
> > > Microsoft SQL-DMO (ODBC SQLState: 42000)
> > >
> > > "Error 229: Execute permission denied on object 'xp_availablemedia',
> > > database 'master', owner 'dbo'."
> > >
> > > Please help. Thanks.
> > >
> > >
> >
> >
>|||Hari,
I found out that both services are started with local system
accounts. Does that mean whoever shut down and re-start the service is the
local system accounts? Or it mean something else? Do I need to re-start both
services with the user id I used to do backup?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23601RbaMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hi,
> The user in which you start the SQL Server and SQL Agent service should
have
> the permission.
> Thanks
> Hari
> MCDBA
>
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> > Thanks, Hari. I have created the user id previously and didn't assign a
> > local win 2k user id to it. May be this is the problem. Now I just
> created
> > a local win 2k user id with the access right. But I don't want to delete
> the
> > sql user id and re-create it again? How can I map the current sql 2k
user
> id
> > with the local win 2k user? Please let me know. Thanks.
> >
> >
> > "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> > news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > Its seems your login account does not have the permissions required to
> > > create a backup
> > > device in hard disk. Please consult your system administrator or
> database
> > > administrator
> > > to obtain the required permissions to write in to the hard disk (Write
> > > permission on the folder you craete the backup file).
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Eric Clapton" <no_spam@.bk.com> wrote in message
> > > news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> > > > I have assigned an user id to a role of db_backupoperator. But after
I
> > > > created a scheduled job to do backup weekly, it won't run at all. No
> > error
> > > > message in the event application. So I go to do the backup
manually.
> I
> > > get
> > > > an error message when I click the "..." button to specify the backup
> > file
> > > > location as following:
> > > >
> > > > Microsoft SQL-DMO (ODBC SQLState: 42000)
> > > >
> > > > "Error 229: Execute permission denied on object 'xp_availablemedia',
> > > > database 'master', owner 'dbo'."
> > > >
> > > > Please help. Thanks.
> > > >
> > > >
> > >
> > >
> >
> >
>

db_backupoperator question

I have assigned an user id to a role of db_backupoperator. But after I
created a scheduled job to do backup weekly, it won't run at all. No error
message in the event application. So I go to do the backup manually. I get
an error message when I click the "..." button to specify the backup file
location as following:
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Error 229: Execute permission denied on object 'xp_availablemedia',
database 'master', owner 'dbo'."
Please help. Thanks.Hi,
Its seems your login account does not have the permissions required to
create a backup
device in hard disk. Please consult your system administrator or database
administrator
to obtain the required permissions to write in to the hard disk (Write
permission on the folder you craete the backup file).
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> I have assigned an user id to a role of db_backupoperator. But after I
> created a scheduled job to do backup weekly, it won't run at all. No error
> message in the event application. So I go to do the backup manually. I
get
> an error message when I click the "..." button to specify the backup file
> location as following:
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Error 229: Execute permission denied on object 'xp_availablemedia',
> database 'master', owner 'dbo'."
> Please help. Thanks.
>|||Thanks, Hari. I have created the user id previously and didn't assign a
local win 2k user id to it. May be this is the problem. Now I just created
a local win 2k user id with the access right. But I don't want to delete the
sql user id and re-create it again? How can I map the current sql 2k user id
with the local win 2k user? Please let me know. Thanks.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
> Hi,
> Its seems your login account does not have the permissions required to
> create a backup
> device in hard disk. Please consult your system administrator or database
> administrator
> to obtain the required permissions to write in to the hard disk (Write
> permission on the folder you craete the backup file).
> Thanks
> Hari
> MCDBA
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
error[vbcol=seagreen]
> get
file[vbcol=seagreen]
>|||Hi,
The user in which you start the SQL Server and SQL Agent service should have
the permission.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> Thanks, Hari. I have created the user id previously and didn't assign a
> local win 2k user id to it. May be this is the problem. Now I just
created
> a local win 2k user id with the access right. But I don't want to delete
the
> sql user id and re-create it again? How can I map the current sql 2k user
id
> with the local win 2k user? Please let me know. Thanks.
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
database[vbcol=seagreen]
> error
I[vbcol=seagreen]
> file
>|||Hari,
I found out that both services are started with local system
accounts. Does that mean whoever shut down and re-start the service is the
local system accounts? Or it mean something else? Do I need to re-start both
services with the user id I used to do backup?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23601RbaMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hi,
> The user in which you start the SQL Server and SQL Agent service should
have
> the permission.
> Thanks
> Hari
> MCDBA
>
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> created
> the
user[vbcol=seagreen]
> id
> database
I[vbcol=seagreen]
manually.[vbcol=seagreen]
> I
>

DB Optimization

SQL 7.0
I scheduled a Optimization job to run weekly once and its taking around 5
hrs .During this time users are getting locked.
What are all the best options to handle this '
We are not able to get a continuous 5 hrs down time for application '
Thx
ShDo you mean index rebuilds?
Index rebuilds acquire locks on the table (exclusive for clustered =indexes and shared for non-clustered); they do require downtime.
SQL Server 7.0 doesn't have an online index defrag option such as the =one provided by SQL Server 2000 (DBCC INDEXDEFRAG).
-- BG, SQL Server MVP
Solid Quality Learning
www.solidqualitylearning.com
"Shamim" <shamim.abdul@.railamerica.com> wrote in message =news:OsxzOzSVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> SQL 7.0
> > I scheduled a Optimization job to run weekly once and its taking =around 5
> hrs .During this time users are getting locked.
> What are all the best options to handle this '
> > We are not able to get a continuous 5 hrs down time for application '
> > Thx
> Sh
> >|||Itzik
An alternative is to use the DBCC command SHOWCONTIG to
get an idea of the fragmentation of your files. It is very
likely that they fragment at different rates. When you get
a feel for how quickly your different tables fragment you
may be able to schedule your index rebuilds in a way that
fits into your available window.
Regards
John|||Thanks Itzik for the reply.
Just wanna know , how a production critical environment handle this issue'
Is it like, transfering application to a hot backup , optimize production db
, restore the downtime transaction log and connect back.
Thx
Sh
"Itzik Ben-Gan" <itzik@.REMOVETHIS.solidqualitylearning.com> wrote in message
news:eVN192SVDHA.1928@.TK2MSFTNGP12.phx.gbl...
Do you mean index rebuilds?
Index rebuilds acquire locks on the table (exclusive for clustered indexes
and shared for non-clustered); they do require downtime.
SQL Server 7.0 doesn't have an online index defrag option such as the one
provided by SQL Server 2000 (DBCC INDEXDEFRAG).
--
BG, SQL Server MVP
Solid Quality Learning
www.solidqualitylearning.com
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:OsxzOzSVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> SQL 7.0
> I scheduled a Optimization job to run weekly once and its taking around 5
> hrs .During this time users are getting locked.
> What are all the best options to handle this '
> We are not able to get a continuous 5 hrs down time for application '
> Thx
> Sh
>

db full backup does not run as part of maintenance plan

db full backup does not run as part of maintenance plan, have full backup
scheduled
to run say 7pm, it does not run, can not find any error logs indicating why
it does
not run, i have reset backup time to say 12pm during day and it runs but
for some
reason it doesnt run at regular time, i have even restarted the
sqlserveragent service but that doesnt seem to be the issue, can a database
maintenance plan get corrupted, should i recreate db maint plan, server is
windows 2000 sql 2000 sp3Where are you looking for errors?
Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest logs.
--
Nik Marshall-Blank MCSD/MCDBA
"Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
> db full backup does not run as part of maintenance plan, have full backup
> scheduled
> to run say 7pm, it does not run, can not find any error logs indicating
> why
> it does
> not run, i have reset backup time to say 12pm during day and it runs but
> for some
> reason it doesnt run at regular time, i have even restarted the
> sqlserveragent service but that doesnt seem to be the issue, can a
> database
> maintenance plan get corrupted, should i recreate db maint plan, server is
> windows 2000 sql 2000 sp3|||i loooked there and there are no files that have been modfified since 9/7/05,
the backup should of run last night 9/8/05, i can find any log files dated
9/08/05
under jobs with EM i see database maintenance plan1 with a status of
Executing Job Step '1(Step 1)'
"Nik Marshall-Blank" wrote:
> Where are you looking for errors?
> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest logs.
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
> > db full backup does not run as part of maintenance plan, have full backup
> > scheduled
> > to run say 7pm, it does not run, can not find any error logs indicating
> > why
> > it does
> > not run, i have reset backup time to say 12pm during day and it runs but
> > for some
> > reason it doesnt run at regular time, i have even restarted the
> > sqlserveragent service but that doesnt seem to be the issue, can a
> > database
> > maintenance plan get corrupted, should i recreate db maint plan, server is
> > windows 2000 sql 2000 sp3
>
>|||Is it backup up to a network share?
Also how long has it been running?
Has it ever run correctly?
Look in current activity to see the command it's executing.
Cancel it and run manually does that work?
Without info from logs you have to just try things.
--
Nik Marshall-Blank MCSD/MCDBA
"Tim Brown" <TimBrown@.discussions.microsoft.com> wrote in message
news:FB311559-ADDB-45B4-A9A1-13888D4F7EAB@.microsoft.com...
>i loooked there and there are no files that have been modfified since
>9/7/05,
> the backup should of run last night 9/8/05, i can find any log files dated
> 9/08/05
> under jobs with EM i see database maintenance plan1 with a status of
> Executing Job Step '1(Step 1)'
> "Nik Marshall-Blank" wrote:
>> Where are you looking for errors?
>> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest
>> logs.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
>> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
>> > db full backup does not run as part of maintenance plan, have full
>> > backup
>> > scheduled
>> > to run say 7pm, it does not run, can not find any error logs indicating
>> > why
>> > it does
>> > not run, i have reset backup time to say 12pm during day and it runs
>> > but
>> > for some
>> > reason it doesnt run at regular time, i have even restarted the
>> > sqlserveragent service but that doesnt seem to be the issue, can a
>> > database
>> > maintenance plan get corrupted, should i recreate db maint plan, server
>> > is
>> > windows 2000 sql 2000 sp3
>>|||Hi,
Looks like you are looking into some wrong directory for Logs. Read the
error log using the belwo command from Query analyzer:-
Xp_readerrorlog
Verify any entries for backup.
If you dont have ; then go to SQL Agent jobs-- there you will be having an
entry for your maintenance plan. Just right click and execute the job
and see the job status; by refreshing the enterprise manager.
Thanks
Hari
SQL Server MVP
"Tim Brown" <TimBrown@.discussions.microsoft.com> wrote in message
news:FB311559-ADDB-45B4-A9A1-13888D4F7EAB@.microsoft.com...
>i loooked there and there are no files that have been modfified since
>9/7/05,
> the backup should of run last night 9/8/05, i can find any log files dated
> 9/08/05
> under jobs with EM i see database maintenance plan1 with a status of
> Executing Job Step '1(Step 1)'
> "Nik Marshall-Blank" wrote:
>> Where are you looking for errors?
>> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest
>> logs.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
>> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
>> > db full backup does not run as part of maintenance plan, have full
>> > backup
>> > scheduled
>> > to run say 7pm, it does not run, can not find any error logs indicating
>> > why
>> > it does
>> > not run, i have reset backup time to say 12pm during day and it runs
>> > but
>> > for some
>> > reason it doesnt run at regular time, i have even restarted the
>> > sqlserveragent service but that doesnt seem to be the issue, can a
>> > database
>> > maintenance plan get corrupted, should i recreate db maint plan, server
>> > is
>> > windows 2000 sql 2000 sp3
>>|||The problem only appears to occur when the "email reporting" feature is enabled
it seems to get hung up in xp_sendmail, with this feature turned off the
backups
run ok daily, with it turned on the backup works but the sql job never
completes
and thus is not run at all the next day, i thought it might be an issue with
mcafee but it still doesnt complete with email reporting turned on, for now
i have
disabled the email reporting feature
"Hari Prasad" wrote:
> Hi,
> Looks like you are looking into some wrong directory for Logs. Read the
> error log using the belwo command from Query analyzer:-
> Xp_readerrorlog
> Verify any entries for backup.
> If you dont have ; then go to SQL Agent jobs-- there you will be having an
> entry for your maintenance plan. Just right click and execute the job
> and see the job status; by refreshing the enterprise manager.
> Thanks
> Hari
> SQL Server MVP
>
> "Tim Brown" <TimBrown@.discussions.microsoft.com> wrote in message
> news:FB311559-ADDB-45B4-A9A1-13888D4F7EAB@.microsoft.com...
> >i loooked there and there are no files that have been modfified since
> >9/7/05,
> > the backup should of run last night 9/8/05, i can find any log files dated
> > 9/08/05
> >
> > under jobs with EM i see database maintenance plan1 with a status of
> > Executing Job Step '1(Step 1)'
> >
> > "Nik Marshall-Blank" wrote:
> >
> >> Where are you looking for errors?
> >>
> >> Look in C:\Program Files\Microsoft SQL Server\MSSQL\LOG fro the latest
> >> logs.
> >>
> >> --
> >> Nik Marshall-Blank MCSD/MCDBA
> >>
> >> "Tim Brown" <Tim Brown@.discussions.microsoft.com> wrote in message
> >> news:4879B39B-29E7-4AE9-A60D-24C8156F5E26@.microsoft.com...
> >> > db full backup does not run as part of maintenance plan, have full
> >> > backup
> >> > scheduled
> >> > to run say 7pm, it does not run, can not find any error logs indicating
> >> > why
> >> > it does
> >> > not run, i have reset backup time to say 12pm during day and it runs
> >> > but
> >> > for some
> >> > reason it doesnt run at regular time, i have even restarted the
> >> > sqlserveragent service but that doesnt seem to be the issue, can a
> >> > database
> >> > maintenance plan get corrupted, should i recreate db maint plan, server
> >> > is
> >> > windows 2000 sql 2000 sp3
> >>
> >>
> >>
>
>