Log Shipping (Configuration)
-
Saturday, March 16, 2013 11:44 AM
Hi All,
If first time i creates log Shipping.
In Secondary Database Settings
Question 1 :-
Initialize Secondary Database TAB
Do you want the Management Studio to restore a backup into the Secondary Database?
Three options are there :-
A) Yes generate a full backup............with restore option button
B) Yes, restore an exciting backup....................... Backup file path with restore option button
C) No. the Secondary database is initialized.
Which one i have to select?
Question 2 :-
Restore Transaction Log TAB
Database state when restoring backup.
Two options are there :-
A) No recovery Mode
B) Standby Mode
Which one i have to select?
Kindly note before answering the 2nd question that i have 1 SQL Server 2012 Standard Licence and i am going to configure Log Shipping for databases in Active and Passive mode.
Thanks for Help!
Regards.....
- Edited by Server.Tech Saturday, March 16, 2013 11:45 AM
All Replies
-
Saturday, March 16, 2013 1:27 PMModerator
Question 1 :-
Completely depends on your situation
Initialize Secondary Database TAB
Do you want the Management Studio to restore a backup into the Secondary Database?
Three options are there :-
A) Yes generate a full backup............with restore option button
This will do a full backup of the database that will then be used to restore as the stand by database
B) Yes, restore an exciting backup....................... Backup file path with restore option button
If you already have an existing full backup then you can use this backup to restore the stand by. If a recent full backup has already been taken using this option will reduce the resources that would have to be used to take another backup.
C) No. the Secondary database is initialized.
Select this option if you have already restored the datbase backup to the standby instance and need only to configure the log shipping options
Which one i have to select?
Question 2 :-
Restore Transaction Log TAB
Database state when restoring backup.
Two options are there :-
A) No recovery Mode
No recovery means that the logs from the primary to the standby will be restored WITH NO RECOVERY. This is used to insure that the standby database remains in RECOVERY meaning that no other actions can be done, such as SELECTing from the database.
B) Standby Mode
Standby mode still allows the log files to be recovered, but the database can have SELECT statements exeuted against it. This can often provide an excellent means of version testing from the primary to the standby database or even used as a reporting solution. HOWEVER in order for transaction logs to be applied the log shipping job must have sole access to the database. Using standby and allowing users to SELECT from the standby database can interrupt the log shipping if users are accessing the database at the same time that the log file(s) are being applied.
David Dye My Blog
- Marked As Answer by Server.Tech Sunday, March 17, 2013 10:14 AM
-
Sunday, March 17, 2013 10:26 AM
Hello David,
Which mode you recommend when I deploy secondary server on my Disaster Site in passive mode to save second licence?
Thanks for Help!
-
Sunday, March 17, 2013 9:12 PM
Hello David,
Which mode you recommend when I deploy secondary server on my Disaster Site in passive mode to save second licence?
Thanks for Help!
This depends on your purpose of doing log shipping?? only for DR or DR+Other options (such as reporting). In stand by mode,users can query the secondary database where as recovering mode, it is not possible. we do 'leave the database Recovering mode' but this is based on our requirement..so, please let us know your requirement for doing Log shipping...Hope it Helps!!
-
Monday, March 18, 2013 3:31 AM
Only for DR purpose........
-
Monday, March 18, 2013 4:13 AM
Only for DR purpose........
I would do it in "Recovering mode" then..Hope it Helps!!
.png)
