SQL Server Performance

Size of the database on logshipping

Discussion in 'SQL Server Log Shipping' started by lara99, Mar 19, 2008.

  1. lara99 New Member

    hi all a quick question if we want to implement logshipping then let's say its running if i want to increase the size of the
    database on the primary server, how should I do it on the secondary server.I mean to ask how should we increase the size
    of the database on the secondeary server.
    Would be greatful if i get some respone thanks.
  2. ghemant Moderator

    Hi,
    You can alter size of your database on primary server, but you can not change it on seconday server as it is in standby and readonly mode.
  3. satya Moderator

    do you have any disk free space issues>?
    If so you can perform the change on the primary server, stop the log shipping and restore the databsae to secondary to take this afect and then continue log shipping.

Share This Page