What is triggering these snapshot backups? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

What is triggering these snapshot backups?

Author

Topic

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2014-02-14 : 10:56:20

I ran a query showing our backups where mysteriously being completed. Then I realized these are snapshot backups.

I got stuck on this. Any direction would be helpful.

- There is no SQL Server job for this, how can I find out what is triggering this?
- The file name is strange (Ex: {2BA11827-A5D9-464E-A5AF-E5D5F441BE2B}8) what is this and how could I restore it?

-- Backups
SELECT backup_finish_date, is_snapshot, database_name, physical_device_name
FROM msdb.dbo.backupset, msdb.dbo.backupmediafamily 
where msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
order by msdb.dbo.backupset.backup_finish_date desc

allenhadler
Starting Member

3 Posts

Posted - 2014-02-14 : 13:16:54

Have you tried SQL Server Profiler durring the time this backup starts?

Allen Hadler

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2014-03-17 : 14:02:46

quote:
Originally posted by allenhadler

Have you tried SQL Server Profiler durring the time this backup starts?

Allen Hadler

Good idea. This is what I got, statements like:

BACKUP DATABASE [model] TO VIRTUAL_DEVICE='BE_SQLAgent-model__212b2caf_542f_4964_bf07_6bc48e5f7705_' WITH name='Backup Exec SQL Server Agent', description ='Snapshot Full', SNAPSHOT

It was application 'Symantec Backup Exec (TM)'.

Can anyone share pros and/or cons of this backup method.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources