Stop seconday database when it is in restoring state

[mohitsahu]

Hi All,

We are planning to perform Switch from primary  to secondary server by using Libelle tool.

Before switch we have planned to increase the server resources and make it same as primary.

So for that we need to stop database running on secondary server. and database is in restoring mode.

So my question is it good to simply stop the database and when resources are increased start the database again.

If yes: Then database will come to restore stage again?

If No: Then what other strategy should we take?

Regards,

Mohit

[Sriram2009]

Hi Mohit

Yes its simple shutdown & start the secondary server during the time primary restore stage. before that you can perform the truncate log backup in primary, check the log truncate completed on both servers and than do the hardware maintenance during this process keep an eye on log DB

Regards

Ram