Monday, March 12, 2012

Mysterious backup jobs

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_PID1352TID4860BID0T
S1696503312VD0'}).
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...
quote:

> 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_PID1352TID4860BID0T
S1696503312VD0'}).
> 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...
quote:

> 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...
and[QUOTE]
contain[QUOTE]
1[QUOTE]
>

No comments:

Post a Comment