![]() Backs up the database- For this, it needs to know the name of the database to backup and full path and file name where the backup will be stored.SQLCMD is used to run the script so it is necessary that this file be run on the same machine where SQL Express is installed. This document explains how to create and execute these scripts.Ī SQL script is needed to backup the SiteAudit database and to subsequently shrink the log file. This requires one to create a batch file that is periodically executed to perform the backup and shrinking. The SQL Agent is not available if using Microsoft SQL Express, therefore the second way to automate a backup is needed. ![]() The preferred method is via Microsoft SQL Management Studio to schedule the task however, the SQL Agent must be installed and running in order to run the scripts that do the backups. There are chiefly two ways to create a SiteAudit database backup and shrink a log file. In fact, it is recommended to keep a backup of the database on another medium in the event of a hardware failure. Backing up the database ensures that it can be restored in the event of data loss or corruption. It is highly recommended that users regularly backup their Netaphor SiteAudit™ database and shrink the associated log file. This article explains how to schedule SQL database backups and log file shrinking via script using the Windows Task Scheduler. Scheduling SQL Backup & Shrinking Using the Windows Task Scheduler
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |