Data Backup and Recovery

backup all instance and DB without configure again




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?





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.



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




then there is a problem with the backup.

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


Register for Insight 2021 Digital

INSIGHT 2021 Digital: Meet the Specialists 2

On October 20-22, gear up for a fully digital, totally immersive virtual experience with a downright legendary lineup of world-renowned specialists. Tune in for visionary conversations, solution deep dives, technical sessions and more.

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