May 22, 2018 at 8:53 am
Hi ,
Daily database backups are running, but there is no sql job.
And backups are saving in physical drive.
How to find the backup job details.
SQL: Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Standard Edition (64-bit)
OS: Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)
Thank you !!
May 22, 2018 at 9:05 am
adisql - Tuesday, May 22, 2018 8:53 AMHi ,Daily database backups are running, but there is no sql job.
And backups are saving in physical drive.
How to find the backup job details.SQL: Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Standard Edition (64-bit)
OS: Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)Thank you !!
Did you check the SQL Server error log? The backup tables in msdb would also have more information - backupset, backupmediaset, backupmediafamily, backupfile, etc.
Sue
May 22, 2018 at 9:27 am
Sue_H - Tuesday, May 22, 2018 9:05 AMadisql - Tuesday, May 22, 2018 8:53 AMHi ,Daily database backups are running, but there is no sql job.
And backups are saving in physical drive.
How to find the backup job details.SQL: Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Standard Edition (64-bit)
OS: Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)Thank you !!
Did you check the SQL Server error log? The backup tables in msdb would also have more information - backupset, backupmediaset, backupmediafamily, backupfile, etc.
Sue
Yes i verified SQLServer error log and msdb - backupset, backupmediaset, backupmediafamily, backupfile, etc.
for example:- below is the backup information for a database in error log.
Database backed up. Database: Expdatabase, creation date(time): 2016/04/30(00:46:38), pages dumped: 2182, first LSN: 128:344:217, last LSN: 128:434:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}). This is an informational message only. No user action is required.
I need to find how the backup is running daily.
May 22, 2018 at 9:38 am
adisql - Tuesday, May 22, 2018 9:27 AMYes i verified SQLServer error log and msdb - backupset, backupmediaset, backupmediafamily, backupfile, etc.
for example:- below is the backup information for a database in error log.Database backed up. Database: Expdatabase, creation date(time): 2016/04/30(00:46:38), pages dumped: 2182, first LSN: 128:344:217, last LSN: 128:434:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}). This is an informational message only. No user action is required.
I need to find how the backup is running daily.
I think these are triggered from 3rd party backup tools. So there is no compulsory to have jobs in SQL Server.
TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}
Thank You.
Regards,
Raghavender Chavva
May 22, 2018 at 9:56 am
Raghavender Chavva - Tuesday, May 22, 2018 9:38 AMadisql - Tuesday, May 22, 2018 9:27 AMYes i verified SQLServer error log and msdb - backupset, backupmediaset, backupmediafamily, backupfile, etc.
for example:- below is the backup information for a database in error log.Database backed up. Database: Expdatabase, creation date(time): 2016/04/30(00:46:38), pages dumped: 2182, first LSN: 128:344:217, last LSN: 128:434:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}). This is an informational message only. No user action is required.
I need to find how the backup is running daily.
I think these are triggered from 3rd party backup tools. So there is no compulsory to have jobs in SQL Server.
TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}
There is no 3rd party backup tool .
May 22, 2018 at 11:02 am
adisql - Tuesday, May 22, 2018 9:56 AMRaghavender Chavva - Tuesday, May 22, 2018 9:38 AMadisql - Tuesday, May 22, 2018 9:27 AMYes i verified SQLServer error log and msdb - backupset, backupmediaset, backupmediafamily, backupfile, etc.
for example:- below is the backup information for a database in error log.Database backed up. Database: Expdatabase, creation date(time): 2016/04/30(00:46:38), pages dumped: 2182, first LSN: 128:344:217, last LSN: 128:434:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}). This is an informational message only. No user action is required.
I need to find how the backup is running daily.
I think these are triggered from 3rd party backup tools. So there is no compulsory to have jobs in SQL Server.
TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}
There is no 3rd party backup tool .
You do have something outside of SQL Server doing backups. And hyper-v snapshots would be outside of SQL Server and would use VSS. Other Agents from backup specific products would show the same thing.
Sue
May 22, 2018 at 11:07 am
Sue_H - Tuesday, May 22, 2018 11:02 AMadisql - Tuesday, May 22, 2018 9:56 AMRaghavender Chavva - Tuesday, May 22, 2018 9:38 AMadisql - Tuesday, May 22, 2018 9:27 AMYes i verified SQLServer error log and msdb - backupset, backupmediaset, backupmediafamily, backupfile, etc.
for example:- below is the backup information for a database in error log.Database backed up. Database: Expdatabase, creation date(time): 2016/04/30(00:46:38), pages dumped: 2182, first LSN: 128:344:217, last LSN: 128:434:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}). This is an informational message only. No user action is required.
I need to find how the backup is running daily.
I think these are triggered from 3rd party backup tools. So there is no compulsory to have jobs in SQL Server.
TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}
There is no 3rd party backup tool .
You do have something outside of SQL Server doing backups. And hyper-v snapshots would be outside of SQL Server and would use VSS. Other Agents from backup specific products would show the same thing.
Sue
Thank you. Any idea where should i check .
May 22, 2018 at 11:17 am
adisql - Tuesday, May 22, 2018 11:07 AMSue_H - Tuesday, May 22, 2018 11:02 AMadisql - Tuesday, May 22, 2018 9:56 AMRaghavender Chavva - Tuesday, May 22, 2018 9:38 AMadisql - Tuesday, May 22, 2018 9:27 AMYes i verified SQLServer error log and msdb - backupset, backupmediaset, backupmediafamily, backupfile, etc.
for example:- below is the backup information for a database in error log.Database backed up. Database: Expdatabase, creation date(time): 2016/04/30(00:46:38), pages dumped: 2182, first LSN: 128:344:217, last LSN: 128:434:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}). This is an informational message only. No user action is required.
I need to find how the backup is running daily.
I think these are triggered from 3rd party backup tools. So there is no compulsory to have jobs in SQL Server.
TYPE=VIRTUAL_DEVICE: {'{1T035G3A-91D0-45DC-8A8C-71696CE9DHBB}7'}
There is no 3rd party backup tool .
You do have something outside of SQL Server doing backups. And hyper-v snapshots would be outside of SQL Server and would use VSS. Other Agents from backup specific products would show the same thing.
Sue
Thank you. Any idea where should i check .
If you personally aren't aware of any specific backup products then I would suspect the hyper-v snapshots. Check the Windows event logs on that server or check with whoever manages those virtual servers.
Sue
May 22, 2018 at 11:42 am
run proc-explorer (https://docs.microsoft.com/en-us/sysinternals/downloads/process-utilities ) or task manager (maybe) to monitor what application is doing backup.. (you may look at timestamp of the backups to find when should you run the tool)
May 23, 2018 at 2:10 am
The }7} at the end of the file name indicates to me that this is not a database backup, but an application-consistent VM snapshot. Talk to your VM admins to see if this is the case.
May 23, 2018 at 2:34 am
Search the registry on the server, this will give you a better idea of the software being used, look for 1T035G3A-91D0-45DC-8A8C-71696CE9DHBB
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply