March 21, 2013 at 3:40 am
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
March 21, 2013 at 3:45 am
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.
March 21, 2013 at 4:12 am
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?
March 21, 2013 at 4:19 am
Transactional replication?
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
March 21, 2013 at 5:16 am
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;-)
March 21, 2013 at 12:31 pm
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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply