SQL Server Performance

huge db size in logshipping

Discussion in 'SQL Server 2005 Log Shipping' started by Deepak Rangarajan, Jun 16, 2007.

  1. Deepak Rangarajan New Member

    Guys,
    i had restored a full backup of size 220gb ..in my cob server i.e destination server in logshipping......as there was a problem in logshipping.....how long do u think will it take to restore a db of such huge size???.....i took just 2hrs ......wondering how it got over so early!!!!!!!!!!there wasnt many jobs configured....it was totally dedicated for logshipping.......

    rgds
    deepak
  2. MohammedU New Member

    When you are restoring any database it depends on the throughput...
    If you are using the network backup then it depends on the network configuration and or NIC card configuration of source and destination server...
    When you restore big databases...first time it may take longer because it has to allocate the space...

    You can monitor the restore throughput using perfmon backup throughput counter...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. Deepak Rangarajan New Member

    Thanks for the info

    Regards
    Deepak
    SQL DBA
  4. satya Moderator

    I have seen questions asking why the restore is slow, but this is typical as you wondered why it has complete so early [<img src='/community/emoticons/emotion-1.gif' alt=':)' />], as explained it is purely dependant upon the system resource usage on the destination server and also if you have copied that file locally on that server then yes the throughput is 100%.<br /><br />Also<a target="_blank" href=http://sqlserver-qa.net/blogs/perftune/archive/2007/06/05/have-you-looked-at-sql-server-managment-pack.aspx>http://sqlserver-qa.net/blogs/perftune/archive/2007/06/05/have-you-looked-at-sql-server-managment-pack.aspx</a> look at SQL Management pack in thsi case.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Share This Page