Showing posts with label sources. Show all posts
Showing posts with label sources. Show all posts

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_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
> >
> >
>

Friday, March 9, 2012

MYODBC Drivers for sql server 2005

SO I installed the MyOdbc drivers 5.0 and 3.51 and then went into my Data Sources(ODBC) drivers in my Administrative Control Panel

I then proceeded to add the DSN Under System DSN and I also tried User DSN

When I try to use the import/export tool in my SQL Server 2005 Management studio I don't get presented with the MySql drivers at all for a source

why is this?

Trust me you don't need MySQL ODBC driver in SQL Server to move MySQL data to SQL Server, so tell me what you are trying to do and I will tell you how to do it. Hope this helps.|||

oh well that's pretty much it

The sites php with a mysql DB

I'm making it .NET with an MS SQL DB

So just copying the table data and structure to MS SQL

|||

You can use OLE-DB driver to import MySQL data and table structure if it is not in the import/export wizard look for it in DTS/SSIS, another option is to use OPENROWSET or OPENQUERY in SQL Server to connect to MySQL run a search for all of the above in SQL Server BOL(books online). Hope this helps.