0

I have a problem with SQL Server backup on the MS SQL Server 2008R2 (SP1) 10.50.2500.

Basically there is a maintenance plan backing up SQL databases into the physical_device_id which is showing up as a string of numbers similar to UUID ({761607B3-XXXX-XXXX-XXXX-XXXXXXXXXXXX}11}), the software_vendor_id = 4608 and the user_name = NT AUTHORITY\SYSTEM.

When trying to access the existing maintenance plan:

use msdb

select * from sysmaintplan_sublpans
select * from sysmaintplan_plans 

I have no output.

Any help will be much appreciated!

1 Answer 1

0

The database server is being backed up by a third party tool not the maintenance plans. The following query will show you the backup vendor information

select 
 software_vendor_id
 ,name
 ,description
 ,user_name
from msdb.dbo.backupset
2
  • Thanks Sporri as the software_vendor_id is 4608 it is the maintenance plan? (please correct me if I'm wrong). The name and description fields are NULL, Oct 11, 2016 at 16:34
  • The software_vendor_id is I think always 4608, Then the backup process is not registering itself. check select * from msdb.dbo.backupset and you will see the path to where the backups are made, that could help
    – Spörri
    Oct 12, 2016 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.