Data Backup and Recovery

backup all instance and DB without configure again

do
2,726 Views

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

3 REPLIES 3

dmauro
2,723 Views

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.

 

do
2,708 Views

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
2,698 Views

then there is a problem with the backup.

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

 

Public