Backing up a database by using the transaction log shipping feature of SQL Server 2008

One: System requirements

Database server, name server-dw,windows Server 2003 X64, install SQL Server 2008, the database that needs to be backed up is "jkl_dw".

Backup server, name server-etl,windows Server 2003 X32, install SQL Server 2008.

Two: Preparation work

1. Create a folder on the Server-etl that holds the backup database, which is named "JKLDW" in this case.

2. Create a folder on the Server-etl that holds the transaction log for the backup data. This example is named "Logbackup," and then shares this folder, and the share name is "server-etl\logbackup$."

3. Create a folder on the Server-etl that holds the transaction log replicated for the restored database. This example is named "Logcopy," and then shares this folder, and the share name is "server-etl\logcopy$."

4, create a full backup of the database "Jkl_dw".

(1) Backup Database-General page

At destination, select the path to the database backup file.

(2) Backup Database-Options page

Overwrite media: Change to "back up to new media set and clear all existing backup sets", and then name it casually.

Reliability: Check "Validate backup after Completion" and "verify checksum before writing to media".

Compression: Select "Compress Backup", can save about 80% space.