Full & T-log

Question

Hi Team,

we planning to configure Logshipping on the Principal server from here to i have to take full & T-log backups, then i have to configure logshipping, it is correct or not.

if any thing wrong please correct me.

Tx

---

subu

Answer 1

Subu,

It is up to you, but its safe to have a full backup before configuring log shipping , actualy while you configure Secondary Database settings, there is an option to have a backup now  or use the existing backup.

Here is the step by step instruction to configure log shipping http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/

---

Thanks
Manish

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Hi Team

As per my knowledge we have to take ful &T-logs backups, before configuring logshipping, then only we have to configure logshipping.

---

subu

Answer 3

HI Subbu,

to configure log shipping we have to set database in FULL recovery mode, to check in which recovery mode database is run this query

select name, recovery_model_desc from sys.databases

check my blog for configuring log shipping in simple steps

http://sqlservr.blog.com/2012/05/27/log-shipping-in-simple-steps/

please check the requirements like

both the SQL Servers should be started with the same domain name,

databa must be in FULL Recovery model

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 4

Hi

Which SQL Server version are you using? if it is 2005 or above I'll strongly suggest to use Database Mirroring for DR purposes

http://msdn.microsoft.com/en-us/library/ms189852.aspx

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 5

The simple answer is: If you have a full backup before you configure Logshipping you don't need to run one when you configure the secondary... The way is always the same: You need a full backup to initialize the secondary and all transaction log backups that have been taken between the full backup and the current state to initialize logshipping. How and when you take those backups + restores is pretty much up to you.

Answer 6

Subu,

Yes you are correct but please check below links as well for step by step tutorial with screenshots.

Step By Step Guide to Configure the Log-Shipping On SQL Server

Configuration Of Transaction Log shipping In SQL Server Step By Step

---

Nareshkar Pakanati 

MCTS, MCITP IT Specialist
My Blog: www.mssqlfix.com
Twitter: @mssqlfix
-------------------------------------------------------
Please mark the post as Answered if it answers your question.
-------------------------------------------------------