How can you plan the logshipping before processing?
- 1 Answers
- 2417 Views
- ACC, I also Faced
- E-Mail Answers
Answer Posted / Swatantra Kumar Maurya
To plan log shipping before processing, follow these steps:
1. Create a primary database and a standby database.
2. Determine the transaction log backup frequency for your primary database.
3. Set up the necessary SQL Server Agent jobs for backup and copying log files to the standby server.
4. Configure the standby server to restore the transaction logs in the order they were taken from the primary server.
5. Test the log shipping configuration to ensure it works as expected.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
