Deonet Backup Solutions 5.2.7.0 manual Requirements

Better Edge Backup v5.2

User Guide

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.1Requirements

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.2Overview

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

Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved. Page 66 of 121 (September 16, 2008)