SQL Server Performance Forum – Threads Archive

Logshipping question

I am about to setup logshipping and here’s what i am going to do. I would like you folks to take a look at my steps and tell me, if i am doing something different: Steps: 1) On primary server, create a shared folder. Eg: c:log
2) Backup the database on primary server. (The database is running under fullrecovery)
3) Go to secondary server and create a shared folder too. Eg: c:log
4) Restore the database on secondary server with standby option.
5) Configure the database on primary server for logshipping with 15 minutes of
logshipping frequency.
6) Do some DML on primary and this should be applied to secondary on the next log backup. Is there anything missing here? Appreciated if you guys please let me know. Many thanks,
Cali

Seems fine …to set it up refer the link below http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx Cheers
Sat
TEST ON TEST SERVER ALWAYS!!!

Thanks for confirmation. The provided link is much better and talks in greater detail. Thanks,

Check the following too… http://msmvps.com/blogs/omar/archiv…Ship-on-large-database-that-really-works.aspx http://www.sql-server-performance.com/sql_server_log_shipping.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thank you MohammedU for the links. they are very helpful.

Are you looking to implement Log shipping in 2000 or 2005? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Hi, I think there is a small change in what you said <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> 1) On primary server, create a shared folder. Eg: c:log 2) Backup the database on primary server to shared folder. (The database is running under fullrecovery) 3)Ensure that SQL SERVICE ACCOUNT of the secondary server has modify privileges on the shared folder of primary server,as copy job will run from secondary server accessing the shared folder in primary server 4) Go to secondary server and create a shared folder too. Eg: c:log —-> IS NOT REQUIRED 5) Restore the database on secondary server with standby option. 6) Configure the database on primary server for logshipping with 15 minutes of logshipping frequency. 7) Do some DML on primary and this should be applied to secondary on the next log backup. NOTE: **** A shared folder should be created in primary server.No need to create a share folder in secondary server Pls correct me if i am wrong Regards Deepak SQL DBA

]]>