2015-04-02 12:33 AM - edited 2015-12-18 01:05 AM
I have a multipule instance on the sql server.
when I add a new instance of add a new DB, I have to configure the task schedular again.
Is there a way to configure that it backup all the DB and the instance On the server?
2015-04-02 12:45 AM
yes, if you have a standalone server with multiple instances installed, you just schedule the backup with the hostname of the SQL server, without needing to mention the names of the instances:
new-backup –svr 'Host1' ...
if you prefer the SMSQL GUI, you need to click the top level check box:
instances which you install later (if configured within the same lun's of the other instances and within the correct configuration), they will be backed up too, because the new-backup command will not include a specific instance name and will pick up all instances currently installed.
hope that helps,
Domenico Di Mauro.