Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
youngb912
Starting Member
14 Posts |
 Posted - 2010-01-27 : 13:37:23
|
| 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. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-27 : 14:09:22
|
| Look under SQL Agent, in SSMS |
 |
|
|
youngb912
Starting Member
14 Posts |
Posted - 2010-01-27 : 14:29:47
|
| Management Studio Express does't have the management option - where SQL Agent is located. I don't have the full SSMS. I have the express edition. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-27 : 14:34:19
|
| Ah, OK. Sorry about that. I'm not familiar with Express.If SQL Agent is still present, but not available from Express Management Studio, then presumably you have to use SQL commands to examine the Jobs (or connect to your Express Database with the full SSMS product) |
|
|
|
youngb912
Starting Member
14 Posts |
Posted - 2010-01-27 : 15:37:18
|
| PROBLEM RESOLVED---------------I used this command to obtain the varous jobs on the server.SELECT [name] FROM msdb..sysjobsThe backup job did show up and I used the following command to remove it - USE msdbEXEC sp_stop_job @job_name = 'DB_backup'Thanks you all for the assistance. My goal was to remove/disable this job. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-27 : 15:55:53
|
Excellent! Thanks for coming back with the details for SQL Express ... that will help the next person that comes along with this question  |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-27 : 17:16:16
|
| why not just create a job to delete backups older than x number of days? this way you'll still have backups but won't fill your hd |
|
|
|
|
|
|
|
|
Database backup