log shipping - [sql server 2008 r2]
You can use log shipping to send
transaction logs from one database (the primary database) to another
(the secondary database) on a constant basis.
Continually backing up the transaction logs from a primary database and then copying and restoring them to a secondary database keeps the secondary database nearly synchronized with the primary database.
The destination server acts as a backup server and provides a way to reallocate query processing from the primary server to one or more read-only secondary servers. Log shipping can be used with databases using the full or bulk-logged recovery models.
Continually backing up the transaction logs from a primary database and then copying and restoring them to a secondary database keeps the secondary database nearly synchronized with the primary database.
The destination server acts as a backup server and provides a way to reallocate query processing from the primary server to one or more read-only secondary servers. Log shipping can be used with databases using the full or bulk-logged recovery models.
 Note |
|---|
| For information about which editions of SQL Server support log shipping, see Features Supported by the Editions of SQL Server 2008 R2. |
| Topic | Description |
|---|---|
| Log Shipping Overview | Introduces log shipping concepts and provides an example of a typical log shipping configuration. |
| Log Shipping Deployment | Describes the steps involved in configuring a database for log shipping. |
| Log Shipping Administration | Contains information about failing over to a log shipping secondary, changing roles between primary and secondary servers, using secondary servers for query processing, removing log shipping, using log shipping as part of a recovery plan, log shipping tables and stored procedures, and monitoring log shipping. |
| Monitoring Log Shipping | Describes the server instance used to monitor log shipping activity and keep log shipping history. |
![Hindari Fungsi di Klausa WHERE [SQL]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrvmmSLY1H8aYPfagD60beCu0ndLDnJZnDgqxfc5u2Wq1fKjSi3g_vbDIPQA0moB2_oa4vC9sqeuo8QvErLDsNh590ECj1ROG_IaeDR5ot0W5JKcWxOZtZMZs-obJLUBrgfK9F7vagPMgZ/s72-c/sql-select-clause-13-638.jpg)
![Hindari Fungsi di Klausa WHERE [SQL]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrvmmSLY1H8aYPfagD60beCu0ndLDnJZnDgqxfc5u2Wq1fKjSi3g_vbDIPQA0moB2_oa4vC9sqeuo8QvErLDsNh590ECj1ROG_IaeDR5ot0W5JKcWxOZtZMZs-obJLUBrgfK9F7vagPMgZ/w72-h72-p-k-no-nu/sql-select-clause-13-638.jpg)
Leave a Comment