DB backups not secheduled

Question

I have done backup plan to backup 1 DB . When look in the log i can see that the system has taken backup of all databases (master , reportserver ...etc) . However on the drive where data are backed up , i can see only my DB for which i have done the bakup plan .

Questions:

1) why i am seeing in the log that there were many DB backed up .

2) If 1) is true where are these backups ?

Any comment will help.

Answer 1

The problem was that i was doing a classic backup using windows server utility (nothing to have with DB backup) for some folder . I was doing backup for only 1 folder in the root of the C:\ drive .

But somehow when this backup starts it freezes the I/O on each database, then it resumes the I/O of all databases and finally all DB are backed up .

Answer 2

Probable reasons i might think of, why you see those DB's being backed up are:

1. You have an SQL Agent job scheduled somewhere to take those backups:

2. Either a Maintenance plan exist which is taking those backups.

3. May be there are AD-HOC backups being taken via SSMS:

4. This may be the reason you might be seeing those DB's getting backed up due to VSS (Volume Shadow copy service).

In order to check this, please run the query below from here to find how are you're DB's getting backed up.This will give you the application name which will help the cause on how these backups are occurring.

SET NOCOUNT ON;
--this version reads all trace files
declare @path  nvarchar(100)
set @path = (select top 1 [path] from sys.traces where is_default = 1)
set @path = (select reverse(right(reverse(@path), (Len(@path) - (PATIndex('%[_]%', reverse(@path)))))) + '.trc')


SELECT  STE.name AS EventClassName,
       ST.StartTime ,
        ST.LoginName ,
        ST.HostName ,
        ST.ApplicationName ,
        ST.TextData
FROM    sys.fn_trace_gettable((@path), DEFAULT) ST
INNER JOIN sys.trace_events STE ON ST.EventClass = STE.trace_event_id
WHERE   TextData LIKE '%backup%' AND SPID <> @@SPID
ORDER BY StartTime DESC;