Better Edge Backup v5.2
User Guide
Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved.
Page 66 of 121 (September 16, 2008)
This chapter will describe in details how to use Better Edge Backup to backup your Microsoft SQL Server 7.0 /
2000 server and how you can restore your Microsoft SQL Se rver 7.0 / 2000 server from the backup files.
10.1 Requirements
i. Better Edge Backup must be installed on to the computer running Microsoft SQL Server.
ii. Data from Microsoft SQL Server will be backed up to a temporary directory before they are sent to
Offsite Backup Server. Please make sure you have sufficient space on your computer to store
these data when you run the backup job.
10.2 Overview
Better Edge Backup will backup your Mi crosoft SQL Server database(s) by taking the following steps:
i. Before running any backup activities, Bette r Edge Backup will run all Pre-Commands of the backup
set.
ii. For each database that is to be backed up, Better Edge Backup will issue a database / transaction
log backup command to Microsoft SQL Server to ba ckup each database to a Microsoft SQL Server
database backup file (*.bak file) and save it in the temporary directory you specified.
iii. After all *.bak files have been spooled to the temporary directories, Better Edge Backup will run
all Post-Commands of the backup set.
iv. Upload all files copied to the temporary directory to the Offsite Backup Server.
v. Remove temporary files from the temporary di rectory if [Setting] -> [Temporary Directory for
storing backup files] is enabled