Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Transaction Log Shipping\Applying

Posted on 2009-05-20
2
Medium Priority
?
391 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
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

782 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