Strange Database backup

Question

Post reply

Strange Database backup

dba888

Newbie

Points: 4
More actions
January 27, 2010 at 11:58 am

#214897

My C:\ drive is being filled by SQL server backup. I'm using Management Studio express edition and can't locate where the backup is scheduled. The backup appears to run every night. I check scheduled task in Window and can't see any batch job schedule to execute. Management Studio doesn't have the option to see jobs.
I will like to locate the job that is performing the daily backup and remove/stop it. How do I find the job that is performing the BACKUP? Is there a script?
Here is the Window event log but I can't determine the source of this job -
Database backed up. Database: Pet_1, creation date(time): 2008/10/22(15:40:14), pages dumped: 116157, first LSN: 17335:602:150, last LSN: 17336:330:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\PeT\PreT_4_db_201001080200.BAK'}). This is an informational message only. No user action is required.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Could there be something in the application that is using SQL Server Express that is triggering the backup?

dba888 Newbie Points: 4 More actions · Answer 2

The application doesn't have that capability. It's an application use to monitor devices. I don't know if a script was executed that is running within the database. Any help will be appreciated.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

Use profiler since the backup happens every night, include the login name, host name and application name columns.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dba888 Newbie Points: 4 More actions · Answer 4

I don't see profile. This is SQL express. Therefore most feature are absent, e.g SQL agent.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

Then use a server-side trace. It's profiler without the Gui.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dba888 Newbie Points: 4 More actions · Answer 6

ISSUE RESOLVED

----------------

I used this command to obtain the varous jobs on the server.

SELECT [name]

FROM msdb..sysjobs

The backup job did show up and I used the following command to remove it -

USE msdb

EXEC sp_stop_job @job_name = 'DB_backup'

Thanks you all for the assistance. My goal was to remove/disable this job.

Steve Jones - SSC Editor SSC Guru Points: 739661 More actions · Answer 7

That procedure stops a job that is running. It doesn't disable a job.

You need sp_update_job (http://msdn.microsoft.com/en-us/library/aa260379%28SQL.80%29.aspx)