backup all instance and DB without configure again

[do]

Hi

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?

Doron

[dmauro]

Hi Doron,

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.

[do]

when I use the GUI and add a new instace It dont backup the new instance, even I mark the top of the tree.

[dmauro]

then there is a problem with the backup.

you may want to start by looking at the backup report.