October 11, 2012 at 8:46 am
I have Db almost 700GB which we daily restore on Production after making back up on build server. As the size is increasing back and restore is taking longer. Is there any alternate some one can suggest. one I can think of it is use SSIS and do CDC from build server to production server but the problem is with indexes. any help is appreciatiable.
Thanks,
Kick
October 11, 2012 at 9:48 am
If having the database in read only mode is OK, you could restore the database into standby mode, and then apply transaction log backups to roll it forward each day.
October 11, 2012 at 12:24 pm
What options you have depend on why you're doing this. If it's to have a standby server, then replication or mirroring or log shipping (already mentioned by another) might be better.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 11, 2012 at 1:03 pm
we do not want to take server down as its been used by International users. So building on seperate server and restoring after back up by making it offline for 1 and 1/2 hour.
October 11, 2012 at 1:06 pm
I actaully thought of doing diff back up and restoring but again it will require server to offline for at least an hour or so.
October 11, 2012 at 1:22 pm
That still doesn't say what the second server is for.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 11, 2012 at 1:41 pm
Second server is used for reportings, Apps etc..
October 11, 2012 at 2:39 pm
Transactional replication. Database mirroring with snapshots.
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
October 12, 2012 at 12:36 am
kick_12309 (10/11/2012)
do CDC from build server to production server but the problem is with indexes.
Why indexes are problem here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 7:15 am
Some time we sxpect one more than one millions records in CDC in few tables...
October 16, 2012 at 9:37 am
Try to use Red Gate SQL Backup. It works much faster than native sql backup.
Good luck!
Jacob Milter
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply