Size of the database on logshipping | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Size of the database on logshippinghi 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.
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.
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.