![]() ![]() We should check whether SQL Server Agent is running, started or have stopped. Step 6. When we close the Back-Up Database Task window will be asked “Save changes to the following items”. We can choose several options that look like the below screen shots then click OK button. Step 5. Click Job Schedule Properties and select what are the days and and times you need for the backup. ![]() We should select a path in “Back Up Database Task” window where the need to store database backup looks in the server or local machine looks like below screenshot. Step 4. Select the backup type as “Full” and Select the Database(s) which we need to set automatic daily backups. Now double click “Back Up Database Task” box in the wizard. ![]() Go to Toolbox and click “Back Up Database Task” in General. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |