Follow by Email

Thursday, December 19, 2013

How to change DB instance job schedule for Netapp Snapmanager for SQL Server Busy message

Hi All We have been facing issue with one of our SQL DB instance which is backed up through SNAPMANAGER has been failing with status Snapmanager Server Busy.... So what i have thought is if i change the schedule where no other instances were getting backed up ..... It is always good to have atleast 30mins-1hr between each instance. Please take note that SnapManager for SQL will not follow the windows  task scheduler ( Snapmanager for Exchnage uses windows Task Scheduler ). All i have done to avoid the server busy message is to change the schedule as below and it worked perfectly. Now my backups are successful.

Open SQL Server  Management Studio

Select the DB Instance for which you want to change the SCHEDULE

Now go to SQL Server Agent àDB_Schedule_Nameà Properties

 Select the Job and click Edit

Now you will be able to check and change the scheduled time to run the snapmanager for SQL

1 comment:

  1. Nice news and thanks for sharing this here to let me know this updates,please know the recent updates by visiting this link also…because I had gain some info from here also: SQL Server Jobs