Hi there
I have been working with SMSQL and SME for quite a long time, and I am still perplexed by the fact that the overall design of the scheduling are made the way that is is...
It present a few problems in larger installations, let me give you an example...
Say you have 20 SQL Servers with SMSQL installed and running, they have all been scheduled using the Windows scheduler.
Something happens so that all your backups fail, in my case it can be that the SnapVault target site is down... so I need to restart start that backups on the 20 servers, of cause I could just fire up DFM and do a "Backup Now" on each dataset, but that woud become an inconsistent snapshot which I cannot restore from inside SMSQL...
So basically I need to either login to each server, restart the Windows Scheduler job... or connect to the scheduler from my management PC via the MMC plugin... sadly you can only connect to one server at a time... so it's to say the least, not an easy task.... 🙂
The schedules are shown in the SMSQL GUI (and SME), but you cannot right-click and start it for some reason 🙂
I would like to know how other administrators solve this in larger datacenters ?
I am aware that NetApp has a few solutions to this called Snap Creator Framework or Workflow Automation, but is that the only way to manage this?
The way I have "solved" this, was to google a bit, and ended up with something like this:
$ServerList = get-content Servers.txt
Foreach ($server in $serverlist)
{
write-host $server -fore green
SCHTASKS /Run /s $Server /U <UserName> /P <Password> /TN TaskName
}
A simple powershell script where you put your affected servers in the servers.txt file, and run the script.. it requires that all servers schedule is called by the same name...
A quick fix, maybe it can help someone out there, but I'm really looking for something a bit smarter, and how knows, maybe the SnapManager and DFM will get to work a bit closer in the future, so that the "Backup Now" button would trigger a SnapManager backup insted of just a snapshot of the dataset pointed to...
/Heino