Deonet Backup Solutions 5.2.7.0 - Manual (Page 66)

Better Edge Backup v5.2
User Guide
Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved. Page 66 of 121 (September 16, 2008)
10 Backup/Restore Microsoft SQL Server 7.0 / 2000
(Professional Version Only)
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 Server 7.0 / 2000 server from the backup files.
10.1 Requirements
i. Better Edge Backup must be installed onto 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 Microsoft SQL Server database(s) by taking the following steps:
i. Before running any backup activities, Better 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 backup 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 directory if [Setting] -> [Temporary Directory for
storing backup files] is enabled