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 12:58 am
This was removed by the editor as SPAM
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 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply