Data Backup and Recovery

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

3 REPLIES 3

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:

 

 

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

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.

 

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public