You've now successfully created and executed a database backup job using SQL Backup Master.Download SQL Backup Master 6 latest full version offline complete setup for Windows. If the backup job does not run to successful completion, please review the log file for details.Ĭongratulations. When you're done creating destinations, click the Save button to save the backup job and return to the main window.īack in the main application window, select your newly created backup job and click the Back up now button. 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. Server1 - Specifies an unnamed SQL Server instance on a remote computer named "Server1".Server1\SQLExpress - Specifies the default SQL Express names instance on a remote computer named "Server1".(local) - Specifies the local SQL Server installation (without an instance name).(local)\SQLExpress - Specifies the default SQL Express named instance on the local computer.In the Server name field, enter or select the name of the SQL Server instance to which you are connecting. The Connect to SQL Server window will appear. In the Database Backup Editor window, click the Choose SQL Server button. This will help you to identify it easily in the future. Give your backup job a unique name (and, optionally, a description). The Database Backup Editor window will appear. In the main SQL Backup Master window, select the Backup and Restore tab, then click the New Backup toolbar button. Once installed, start SQL Backup Master via the desktop shortcut or Start menu entry. If you haven't already downloaded and installed SQL Backup Master, please do so now. This tutorial is designed to help you get up and running with SQL Backup Master.
0 kommentar(er)
