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.