The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Data Backup and Recovery

how to backup all sql db in the server

computer_1

hi all.

we sql 2005 with snap manager for sql installed.

on the sql snap backup job i see a list of all the db that the job will backup.

if i add a new Sql DB the job will fail because the new DB is not on the backup job list.

so how do i configure the job to run on a schedule basis and BACKUP ALL DB .. 

thanks a lot..

1 ACCEPTED SOLUTION

qzhang

In the GUI, if you select all dbs on the server, then schedule the backup, the job will backup all dbs. Or from the cmdlet, if no database is specified, meaning use “-d 0”, or no “-d” switch, the cmdlet job will backup all dbs.

Thanks,

-Qing

View solution in original post

1 REPLY 1

qzhang

In the GUI, if you select all dbs on the server, then schedule the backup, the job will backup all dbs. Or from the cmdlet, if no database is specified, meaning use “-d 0”, or no “-d” switch, the cmdlet job will backup all dbs.

Thanks,

-Qing

View solution in original post

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