June 15, 2009 at 8:25 pm
Hi Everybody,
1)Here is a confusing problem with me.Let me know or provide me any links that give information about how to setup Transaction Log Shipping in SQL Server 2005.
2)What is the difference between Network path and Local path and which one is better?
3)Here is my problem goes: As i am having two databases DB1 and DB2 on the same server. Can i make the DB1 as primary server DB and the DB2 as secondary server DB.
4) Is there any full backup required for the DB1 to take the Transaction Log shipping?
5)What is the difference between Standby mode and Norecovery mode
Thanks in advance,
Venu Gopal.K
Software Engineer
INDIA
June 15, 2009 at 10:21 pm
venu_ksheerasagaram (6/15/2009)
Hi Everybody,1)Here is a confusing problem with me.Let me know or provide me any links that give information about how to setup Transaction Log Shipping in SQL Server 2005.
http://msdn.microsoft.com/en-us/library/ms188698(SQL.90).aspx
2)What is the difference between Network path and Local path and which one is better?
Network path is a shared folder placed on a different server. Local path is a folder on the local server.
3)Here is my problem goes: As i am having two databases DB1 and DB2 on the same server. Can i make the DB1 as primary server DB and the DB2 as secondary server DB.
Try this out and let us know the results.
4) Is there any full backup required for the DB1 to take the Transaction Log shipping?
yes. first time, to implement log shipping, you'll need full backup to be restored first(either in standby or no recovery mode).
5)What is the difference between Standby mode and Norecovery mode
Standby Mode - Your secondary database will be available to the users for reading. They can perform select queries till there is any restore of logs not happening on the secondary. The moment a restore begins, all user connections will be dropped.
Norecovery Mode - your secondary database will not be available to users for reading. the database will be in restoring mode which means it is expecting more log files to be restored, which is obviously the case in log shipping.
June 15, 2009 at 11:08 pm
Thank you for your valuable answers.
But a little bit confusion- Is it necessary to give the Networkpath and Local path destinations eventhough my primary and secondary databases are on the same Server itself? or else is it enough to give the local path only?
Is it necessary that both the databases will have the Full backup file existed?
Venu Gopal.K
Software Engineer
INDIA
June 15, 2009 at 11:16 pm
venu_ksheerasagaram (6/15/2009)
But a little bit confusion- Is it necessary to give the Networkpath and Local path destinations eventhough my primary and secondary databases are on the same Server itself? or else is it enough to give the local path only?
If both primary and secondary are on same server, then you need to create a local share. You still need to share the folder path where tran log backups will be kept from the primary server. These files will be picked up by secondary and restored. This network share should be accessible to the sql server agent account.
Is it necessary that both the databases will have the Full backup file existed?
when you are setting up log shipping, you take a backup of the primary and restore on the secondary and then tran logs are applied based on the interval u've chosen.
once you've setup log shippping, there is no further requirement for full backups. you can keep them however depending on your backup strategy.
June 16, 2009 at 12:40 am
Yeah thank you for that,
If u don't mind can u provide me the exact details how to setup a Transaction log shipping in SQL server 2005 along with snapshots.
I am getting a problem while giving the paths. one more here is i am having only one server in which the primary and secondary server are the same.
there are lot of paths to specify in this total setup. Let me know where to specify which path?
Thank you,
Venu Gopal.K
Software Engineer
INDIA
June 16, 2009 at 12:50 am
this link will guide you log shipping setup via wizard.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1309728_mem1,00.html%5B/url%5D
Also go through BOL.
June 17, 2009 at 8:31 am
But a little bit confusion- Is it necessary to give the Networkpath and Local path destinations eventhough my primary and secondary databases are on the same Server itself? or else is it enough to give the local path only?
Log Shipping is mainly used for disaster recovery. There is no point in having both primary and secondary on the same server as it will lead to single point of failure.
Are you trying to set a demo or this is just for learning purpose ? If this is the case then it is fine to play with it.
Hope this helps,
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply