Home » Database » Ms SQL Server 2000 » Sql Server Automated Backup And Restore Procedures
Sql Server Automated Backup And Restore Procedures
799
Category : Database » Ms SQL Server 2000
Servers SQL Server Group (Local) (Windows NT) Management. Jobs (See Figure 1) . Use File Replication Pro to replicate the SQL file from your primary server to .
Download File Free PDF eBooks Download Database Ms SQL Server 2000
Abstract FileReplicationPro (FRP) can be used to backup your SQL Server databases. The replication procedure is not as straight forward as replicating other files due to file locking constraints by SQL server. A backup and restore procedure can be implemented as follows: 1. Use SQL Server to create a database backup file. 2. Replicate the database backup file using FRP. 3. Restore the database backup file using FRP. 4. Use SQL Server to re-create the database from the database backup file. The procedures for creating a database backup file and for restoring the database from the database backup file are almost identical. The only difference is the script written to the step commands window (See step 5 of the Backup/Restore Procedure). This document describes how to perform a backup or restore of your SQL server database.
Backup/Restore Procedure 1. Start an instance of Enterprise Manager, and navigate to the following location of the server in the left task pane of Enterprise manager (see below). Microsoft SQL Servers SQL Server Group (Local) (Windows NT) Management Jobs (See Figure 1). Please note that depending on your servers particular configuration the section “(Local) (Windows NT)” may differ from what is shown.
Favorite Ms SQL Server 2000 PDF File
1950
MS SQL Oracle 10g databases Features Strengths Weaknesses Comparison
category Database » Ms SQL Server 2000
1927
Installation guide for MsSQL
category Database » Ms SQL Server 2000
1083
FIX MSSQL Interface Installation Guide
category Database » Ms SQL Server 2000
2082
MSSQL Server 2000 Installation Guide
category Database » Ms SQL Server 2000
1210
