topic how to backup all sql db in the server in Data Protection https://community.netapp.com/t5/Data-Protection/how-to-backup-all-sql-db-in-the-server/m-p/28863#M8082 <HTML><HEAD></HEAD><BODY><P>hi all.</P><P>we sql 2005 with snap manager for sql installed.</P><P>on the sql snap backup job i see a list of all the db that the job will backup.</P><P>if i add a new Sql DB the job will fail because the new DB is not on the backup job list.</P><P>so how do i configure the job to run on a schedule basis and <STRONG>BACKUP ALL DB</STRONG> ..&nbsp; </P><P>thanks a lot..</P></BODY></HTML> Thu, 05 Jun 2025 06:49:30 GMT computer_1 2025-06-05T06:49:30Z how to backup all sql db in the server https://community.netapp.com/t5/Data-Protection/how-to-backup-all-sql-db-in-the-server/m-p/28863#M8082 <HTML><HEAD></HEAD><BODY><P>hi all.</P><P>we sql 2005 with snap manager for sql installed.</P><P>on the sql snap backup job i see a list of all the db that the job will backup.</P><P>if i add a new Sql DB the job will fail because the new DB is not on the backup job list.</P><P>so how do i configure the job to run on a schedule basis and <STRONG>BACKUP ALL DB</STRONG> ..&nbsp; </P><P>thanks a lot..</P></BODY></HTML> Thu, 05 Jun 2025 06:49:30 GMT https://community.netapp.com/t5/Data-Protection/how-to-backup-all-sql-db-in-the-server/m-p/28863#M8082 computer_1 2025-06-05T06:49:30Z Re: how to backup all sql db in the server https://community.netapp.com/t5/Data-Protection/how-to-backup-all-sql-db-in-the-server/m-p/28868#M8083 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P> </P><P></P><P>Thanks,</P><P></P><P>-Qing</P></BODY></HTML> Wed, 27 Jul 2011 19:09:39 GMT https://community.netapp.com/t5/Data-Protection/how-to-backup-all-sql-db-in-the-server/m-p/28868#M8083 qzhang 2011-07-27T19:09:39Z