For some reasons, my SQL server 2K keeps running some backup jobs whose
sources I cannot locate. I looked into the Database Maintenance Plans and
found only 1 plan I created myself. The job list in SQLserver logs contain
both my plan and activities from this mysterious plan.
Please help me to locate and get rid of these jobs. Below is the log for 1
of them:
Database backed up: Database: Invoices, creation date(time):
2002/08/09(09:11:51), pages dumped: 232, first LSN: 11:388:1, last LSN:
11:390:1, number of dump devices: 1, device information: (FILE=1,
TYPE=VIRTUAL_DEVICE:
{'DBASQL_DB_Invoices_PID1352TID4860BID0TS1696503312VD0'}).
Thanks a million.
BillIt may be a job run by 3rd party backup s/w. Do you use any? And you can
run profiler on that DB to get more clue.....
"Bill Nguyen" <billn_nospam_please@.jaco.com> wrote in message
news:OIXSx742DHA.3224@.tk2msftngp13.phx.gbl...
> For some reasons, my SQL server 2K keeps running some backup jobs whose
> sources I cannot locate. I looked into the Database Maintenance Plans and
> found only 1 plan I created myself. The job list in SQLserver logs contain
> both my plan and activities from this mysterious plan.
> Please help me to locate and get rid of these jobs. Below is the log for 1
> of them:
> Database backed up: Database: Invoices, creation date(time):
> 2002/08/09(09:11:51), pages dumped: 232, first LSN: 11:388:1, last LSN:
> 11:390:1, number of dump devices: 1, device information: (FILE=1,
> TYPE=VIRTUAL_DEVICE:
> {'DBASQL_DB_Invoices_PID1352TID4860BID0TS1696503312VD0'}).
> Thanks a million.
> Bill
>|||Thanks ME!
I'll check my Arcserve backup application to see if it's the case.
Bill
"ME" <PLEASE!> wrote in message
news:O$c1hE52DHA.2000@.TK2MSFTNGP11.phx.gbl...
> It may be a job run by 3rd party backup s/w. Do you use any? And you can
> run profiler on that DB to get more clue.....
>
> "Bill Nguyen" <billn_nospam_please@.jaco.com> wrote in message
> news:OIXSx742DHA.3224@.tk2msftngp13.phx.gbl...
> > For some reasons, my SQL server 2K keeps running some backup jobs whose
> > sources I cannot locate. I looked into the Database Maintenance Plans
and
> > found only 1 plan I created myself. The job list in SQLserver logs
contain
> > both my plan and activities from this mysterious plan.
> > Please help me to locate and get rid of these jobs. Below is the log for
1
> > of them:
> >
> > Database backed up: Database: Invoices, creation date(time):
> > 2002/08/09(09:11:51), pages dumped: 232, first LSN: 11:388:1, last LSN:
> > 11:390:1, number of dump devices: 1, device information: (FILE=1,
> > TYPE=VIRTUAL_DEVICE:
> > {'DBASQL_DB_Invoices_PID1352TID4860BID0TS1696503312VD0'}).
> >
> > Thanks a million.
> > Bill
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment