Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Any Alternate to back up and Restore Expand / Collapse
Author
Message
Posted Thursday, October 11, 2012 8:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
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
Post #1371557
Posted Thursday, October 11, 2012 9:48 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, November 23, 2014 12:50 AM
Points: 3,109, Visits: 11,515
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.




Post #1371615
Posted Thursday, October 11, 2012 12:24 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
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
Post #1371719
Posted Thursday, October 11, 2012 1:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
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.
Post #1371742
Posted Thursday, October 11, 2012 1:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
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.
Post #1371744
Posted Thursday, October 11, 2012 1:22 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
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
Post #1371748
Posted Thursday, October 11, 2012 1:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
Second server is used for reportings, Apps etc..
Post #1371758
Posted Thursday, October 11, 2012 2:39 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 40,427, Visits: 36,877
Transactional replication. Database mirroring with snapshots.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1371785
Posted Friday, October 12, 2012 12:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:03 AM
Points: 2,840, Visits: 3,975
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
Post #1371910
Posted Monday, October 15, 2012 7:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 2:05 PM
Points: 15, Visits: 167
Some time we sxpect one more than one millions records in CDC in few tables...
Post #1372718
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse