Repeat Step 4 if you'd like to send your database backup files to additional storage destinations. To learn more about configuring a specific destination type, please see one of the following help topics: The configuration (settings) window for the selected destination will appear. Under the Destinations heading in the Database Backup Editor window, click the Add toolbar button.Ĭlick the service you'd like to use for storing database backup files, then click the Select button. Step 4 - Decide where to store database backups With this option enabled, new databases created on the target SQL Server in the future will be backed up automatically. Or you can click the Back up all non-system databases checkboxes. Select the databases you wish to back up as part of this job. Once you've connected to a SQL Server instance, the Database Backup Editor window will show available databases with checkboxes next to them. Test the connection by clicking the Test SQL Connection button, then click OK. You can also use the drop-down arrow of the Server name field to find local and remote SQL Server instances, which you can then select. IMPORTANT: If you choose to connect to SQL Server using Windows Authentication, then you should also configure your backup job to run using a specific Windows account.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |