rebuild master database sql server 2008 r2

Here is part of the error message I receive when my backup

That night my SMSQL backup did not run and has been haphazard ever since. USE declare varchar(100) set = N'MaintenancePlan'ĭelete sysmaintplan_log FROM sysmaintplan_subplans AS subplans INNER JOIN sysjobs_view AS syjobs ON subplans.job_id = syjobs.job_id INNER JOIN sysmaintplan_log ON subplans.subplan_id = sysmaintplan_log.subplan_id WHERE (syjobs.name = sysmaintplan_subplans FROM sysmaintplan_subplans AS subplans INNER JOIN sysjobs_view AS syjobs ON subplans.job_id = syjobs.job_id WHERE (syjobs.name = a few attempts (adding maintenance plan, it would not run, deleting it using script, and then re-adding it) my two maintenance After some investigation, I found a script that could remove these maintenance jobs: I attempted to right click and remove the jobs but they would not delete.

The first few times I could not get the jobs to run properly. On December 15th I setup two maintenance jobs using the maintenance wizard. The backups of my databases had been working perfect for about 6 weeks, ever since we go this new SQL server setup. The SMSQL backup really just makes a backup job that I can viewĪnd schedule in SQL Server Management Studio. Netapp's Snapdrive is also installed on the SQL server, it works in conjunction with SMSQL to do the backups. Is Netapp and I use their product called Snapmanger for SQL (SMSQL) to do backups. My SQL Server runs under VMWare with separate volumes (disks) for my system databases, user databases, and log files.

1 (X64) 15:48:46 Copyright (c) MicrosoftĬorporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7600: ) (Hypervisor)

Rebuild master database sql server 2008 r2