Walk-through 5 : Log shipping between two SQL Servers
If you paln to set up , maintain a standby server, you can create log shipping job for your database.
This walk-through will show you:
Walkthroughs
Walk-through 4 : Restore SQL Server database
If a database fails , and you have backed up this database with SQL Server Backup, you can restore the database to the point of failure.
This walk-through will show you:
Walk-through 3 : Scheduling a backup job
After you have created a backup job, you can schedule this backup job now.
This walk-through will show you:
- How to define backup strategy
- How to create a full backup schedule
- How to create a differential backup schedule
- How to a transaction log backup schedule
- How to check job reports
Walk-through 2 : Backing up MS SQL Server database
After configured SQL Server instance and Backup device , it time to begin to back up a database.
Walk-through 1 : Configuring SQL Server Backup
Before backing up a database , you need configure SQL Server instance and Backup device at first.
SQL Server Backup Walkthroughs
Following walkthroughs introduce the important areas of the SQL Server Backup. Each walkthrough gives step-by-step instructions for common scenarios, which makes them a good place to start learning about the product or a particular feature area.
To provide a hands-on introduction to the numerous major features of SQL Server Backup in a clear and ordered manner , we use the professional edition and install it on the same machine as SQL Server.
Walk-through 6 : Using command line to run a job (for v7)
If you plan to integrate SQL Server Backup to other production batch jobs , you can use command line to start a pre-defined job. If your SQL Server Backup is early than 7.0.6.5012 version , please download a latest one to do that.
The command line format as following:
{installation directory}cmdrun.exe [REPORT LEVEL]
Description :
The cmdrun send a run job command to Backup Agent , just like you do it on GUI. cmdrun.exe will not exit until the job finishes.
Walk-through 6 : Using command line to run a job (for v8 later)
If you are using SQL Server Backup v 7 , please click here
To integrate SQL Server Backup to other production batch jobs , you can use command line to start a pre-defined job. Following command line format is for SQL Server Backup v8 or later , Please make sure you are using a latest version of SQL Server Backup product.
The command line format as following:
{installation directory}\SQLServerBackup.exe