| Walk-through 5 : Log shipping with SQL Server Backup Professional Edition If you plan to set up , maintain a standby server, you can create log shipping job for your database. This walk-through will show you: In this walkthrough , we suppose the source and destination database on the same server , that is the primary server just same as the secondary server. The primary database is db1 , and the standby database is dbx. The log shipping job is scheduled to run every 2 hours . Steps : 1, 2, 3, 4, 5, 6, 7 , 8 , 9 1) To create a log shipping job for a database , please turn to Log Shipping child window , and click the "New Job" button.  2) Fill the general information for the job.  3) We select db1 for the source database in primary server and select a device for the log shipping:  4) In "Secondary Server(s)" tab , click the "Add" button to bring up the secondary settings window. We add a secondary server with following settings . The most important thing is that you have to change the secondary database files name because primary and secondary database just on the same server , or the job will fail.  5) Just use the default settings in "Strategy" , "Completion State" , "Compress & Encrypt" , "Date Decrypt" , "Notify" tabs , then click "OK" button to save the job. 6) In Log Shipping child window , we click the "Schedule" button to create a scheduled log shipping task with following settings.  7) Supposed the primary is failed after several days log shipping , we can do following steps to bring up the standby server. 8) Select the log shipping job and click the "Edit" button in Log Shipping child window, turn to the "Completion State" , and change the job's completion state as following:  9) Click the "OK" button to save job ,then click the "Run Now" button to bring up the standby server.  Please note: After you have brought up standby database , if you want to continue to do log shipping on this database, please remember to change the job's completion state back to default settings. |