July 6, 2013 at 1:53 pm
HI
I have 2 servers. I do a full backup of serverA and restore it to ServerB with NORECOVERY.Now I do a differential backup of ServerA after 1 hr and Apply it to ServerB with RECOVERY. So my ServerB become replica of ServerA.
Now going forward, I just want to do differential backups of ServerA and apply them on
ServerB. To achieve this, Do I always need to do a full database restore of ServerA with NORECOVERY and then Apply differential with RECOVERY? Full backup size is big , around 50GB and it takes time to do it everytime. Is there a way just to apply the differential without first restoring the full DB?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 6, 2013 at 2:28 pm
S_Kumar_S (7/6/2013)
HI...Do I always need to do a full database restore of ServerA with NORECOVERY and then Apply differential with RECOVERY?
Yes.
http://msdn.microsoft.com/en-us/library/ms175526.aspx
"A differential backup is based on the most recent, previous full data backup."
July 6, 2013 at 2:46 pm
That's bad. If nothing is changing in full backup, then it shouldn't be required to restore before each differential restore...
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 6, 2013 at 2:51 pm
Have you considered log shipping?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 6, 2013 at 3:06 pm
but log shipping will require my database of ServerB to be in restoring mode always, isn't it? And hence I won't be able to access that.I can affford serverB to be down for few minutes, but not continously..
Erland Sommarskog (7/6/2013)
Have you considered log shipping?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 6, 2013 at 3:21 pm
S_Kumar_S (7/6/2013)
but log shipping will require my database of ServerB to be in restoring mode always, isn't it?
No. You can log ship to Standby mode, which allows you to read the database. Not change it, but read it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2013 at 4:23 pm
That will be a life saver. Can it be implemented using inbuilt log shipping of sql server or I need to prepare any customized scripts?
Any link on this will be appreciated if it is some special case.
GilaMonster (7/6/2013)
S_Kumar_S (7/6/2013)
but log shipping will require my database of ServerB to be in restoring mode always, isn't it?No. You can log ship to Standby mode, which allows you to read the database. Not change it, but read it.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 7, 2013 at 4:57 am
The in-built log shipping feature. As for docs, did you try Books Online?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply