Subscribe

backup all instance and DB without configure again

[ Edited ]

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

Re: backup all instance and DB without configure again

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:

 

 

GUI.PNG

 

 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.

 

Re: backup all instance and DB without configure again

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

 

 

Re: backup all instance and DB without configure again

then there is a problem with the backup.

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