Rouge backup

I have an odd problem on a MS SQL2K box, one database on my server is being
backed up to a file; this appears to be an appended backup and the backup
file is now getting quite big.
The thing is, there isn't a maintenance plan to do the backup of this
database.
My problem is I want to stop the back up, but if there?s no job how can I
do that? Theres nothing to stop
I think I did once have a maintenance plan to back up this database but
that would have been deleted quit some time ago. I've only found this
because I'm running out of space on one of my partitions.
Any help/ideas/suggestions will be very very appreciated.
--
Message posted via http://www.sqlmonster.comThe only thing that a maint plan does is to create a number of SQL Server agent jobs. My guess is
that you have Agent jobs that are performing the backups.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James Green via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ae94125dde5c4afc806c9dbcfd71a49b@.SQLMonster.com...
>I have an odd problem on a MS SQL2K box, one database on my server is being
> backed up to a file; this appears to be an appended backup and the backup
> file is now getting quite big.
> The thing is, there isn't a maintenance plan to do the backup of this
> database.
> My problem is I want to stop the back up, but if there?s no job how can I
> do that? Theres nothing to stop
> I think I did once have a maintenance plan to back up this database but
> that would have been deleted quit some time ago. I've only found this
> because I'm running out of space on one of my partitions.
> Any help/ideas/suggestions will be very very appreciated.
> --
> Message posted via http://www.sqlmonster.com|||Hello James,
As Tibor mentioned, the Maintenance Plan merely creates Jobs as per your
need. Since there are no Maintenance Jobs (as per your mail)
chances are that the backups might be scheduled through OS bacth files
(scheduled from the OS Scheduler itself or executed from a
remote machine also)
Gopi
"James Green via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ae94125dde5c4afc806c9dbcfd71a49b@.SQLMonster.com...
>I have an odd problem on a MS SQL2K box, one database on my server is being
> backed up to a file; this appears to be an appended backup and the backup
> file is now getting quite big.
> The thing is, there isn't a maintenance plan to do the backup of this
> database.
> My problem is I want to stop the back up, but if there?s no job how can I
> do that? Theres nothing to stop
> I think I did once have a maintenance plan to back up this database but
> that would have been deleted quit some time ago. I've only found this
> because I'm running out of space on one of my partitions.
> Any help/ideas/suggestions will be very very appreciated.
> --
> Message posted via http://www.sqlmonster.com|||Adding to my earlier reply, Since you can find out the time at which the
backup happens,
you might want to start the Profiler around that time and find out from
where the Backup job is getting
triggered.
It is not good to have a Production DB being backed up without knowing from
where the
backup is getting triggered.
Gopi
"gopi" <rgopinath@.hotmail.com> wrote in message
news:OBOIBrOFFHA.3736@.TK2MSFTNGP10.phx.gbl...
> Hello James,
> As Tibor mentioned, the Maintenance Plan merely creates Jobs as per your
> need. Since there are no Maintenance Jobs (as per your mail)
> chances are that the backups might be scheduled through OS bacth files
> (scheduled from the OS Scheduler itself or executed from a
> remote machine also)
> Gopi
> "James Green via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:ae94125dde5c4afc806c9dbcfd71a49b@.SQLMonster.com...
>>I have an odd problem on a MS SQL2K box, one database on my server is
>>being
>> backed up to a file; this appears to be an appended backup and the backup
>> file is now getting quite big.
>> The thing is, there isn't a maintenance plan to do the backup of this
>> database.
>> My problem is I want to stop the back up, but if there?s no job how can I
>> do that? Theres nothing to stop
>> I think I did once have a maintenance plan to back up this database but
>> that would have been deleted quit some time ago. I've only found this
>> because I'm running out of space on one of my partitions.
>> Any help/ideas/suggestions will be very very appreciated.
>> --
>> Message posted via http://www.sqlmonster.com
>