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

Database backup and restoration Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 3:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 1:19 PM
Points: 48, Visits: 212
Hello All,

We currently have a backup and restore job which runs on a weekly basis and the database size is more than 10TB.
Split backup method is followed for taking the database backup and the same is restored on another server.During restoration we are seeing very high network utilization which is affecting the ETL load performance.

Is there any best practice while restoring the database on another server?How can the network utilization be minimized?

Please let me know if there is any other better way to do this.

Loads are throughout the week and we do not have a big window either.

Your help would be highly appreciated
Post #1433664
Posted Thursday, March 21, 2013 3:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 10:03 AM
Points: 1,256, Visits: 1,758
Have you tried log shipping?
Log shipping only copies and restores tran logs and you only need a full backup restored once on your destination.


Alex S
Post #1433672
Posted Thursday, March 21, 2013 4:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 1:19 PM
Points: 48, Visits: 212
Hi Alex,

I guess we will not be able to do it as our database is in simple recovery mode.

Is there any other better way?
Post #1433692
Posted Thursday, March 21, 2013 4:19 AM


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 @ 7:59 AM
Points: 41,530, Visits: 34,447
Transactional replication?


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 #1433701
Posted Thursday, March 21, 2013 5:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
kk.86manu (3/21/2013)
We currently have a backup and restore job which runs on a weekly basis and the database size is more than 10TB.Split backup method is followed for taking the database backup and the same is restored on another server.During restoration we are seeing very high network utilization which is affecting the ETL load performance.
Is this a routined process ? if yes then you should look for another approach like log shipping , replication as mentioend above. as playing with 10Tb data every week is not a handy task . IO , network issues always wil be there another things. there could be chances that backup/resotred got failed due to resources crunch.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1433724
Posted Thursday, March 21, 2013 12:31 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:17 AM
Points: 4,379, Visits: 9,470
Talk to your SAN team and vendor - they may have better solutions for producing replicas that you can use for your situation.

Also, you may want to investigate upgrading to 2012 and using mirroring for the environment. Really depends on why you need that additional copy of the database.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #1433964
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse