STEP 4 – ADD A BACKUP DESTINATIONĬlick on the Add button under the Destinations window header. Select the database(s) you want to back up as part of this backup job.Įnabling the Back up all non-system databases option will back up all new databases created on the targeted SQL Server automatically in the future. STEP 3 – SELECT DATABASES TO BACK UPĪfter you’ve connected to a SQL Server instance, the Database Backup Editor window will appear, showing available databases in the Source column. Hit the Test SQL Connection button to test your connection to the SQL Server, then select OK. 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”.
0 Comments
Leave a Reply. |