November 1, 2010 at 2:06 pm
SQL Server 2005 Standard - SP3 - database mirrored with other server instance - Server 2003 latest service packs, 4 gig ram
I have a Control-M server database that has it's own utility for backing up the database and the transaction log. The utilility looks like a DOS utility, so old school. It uses a SQL Login to do its work, so mixed auth.
In the ERRORLOG file I see a transaction log backup that failed at 7AM this morning, but my tranlog backups run at 10AM, 2PM, and 6PM according to requirements. So, where did this come from?
I searched the server for some SQL file, in the install directory of control-m server.
I looked at all the job history tables and didn't see any evidence of a backup.
I have a trace that is running, but didn't capture this event.
Question:
If some 3rd party piece of software runs a SQLCMD or has some built-in schedule in which it runs a Backup command on my database, how can I find the trail of these events and where it came from?
Thanks in advance. (I need to know how this happens, what is going on with my database)
November 2, 2010 at 11:37 am
server side SQL profile would help you catch 3rd part tool initiating command with host name.
November 2, 2010 at 12:01 pm
SSC,
Thanks for the reply.
Wouldn't looking at HostName just give me the name of the server?
http://msdn.microsoft.com/en-us/library/ms186265.aspx
I forgot to mention that Control-M Server is installed on the same box as SQL Server, another requirement.
Al.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply