Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Transaction Log Shipping\Applying

Posted on 2009-05-20
2
Medium Priority
?
388 Views
Last Modified: 2012-06-21
Hi,
We recently installed SQL Server 2005 ( call it Server A) and created few databases on it. We would like to setup a DR server in a remote location for these databases. The plan is to,
1) Create another SQL Server 2005 (server B) in the remote location.
2) take a backup of the databases from A, restore them on B
3) After that backup and ship the transaction logs for each database from server A to server B every night.

Being new to all this , what i am looking for is detailed STEPS/Screen shots , suggestion in achieving Step 3.

regards..

0
Comment
Question by:crishna1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 1500 total points
ID: 24438676
This article is quite good: http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx

(In fact, it's a great site if you haven't been there)
0
 

Author Closing Comment

by:crishna1
ID: 31583688
Other effficient solutions available.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question