Post reply

Database Mode

  • April 1, 2011 at 1:45 am

    #237755

    Hi,

    Does database mode has to be set to Full if you are using clustering? We use Simple mode as our standard. Will this be a prob?

    Thanks

  • April 1, 2011 at 1:58 am

    #1306326

    Clustering places no restrictions on the recovery model you need to use, so you can still use SIMPLE if you want.

    Just understand that setting the recovery model to SIMPLE is the same as saying "I don't mind losing all the changes I made since the last full backup"

  • April 1, 2011 at 2:37 am

    #1306337

    Thanks, and our data is replicated and we have a very controlled environment.

  • April 1, 2011 at 3:05 am

    #1306345

    clustering is at server level and for server high availability not the database. So even if your perticualr user database failed to bring online, it doesnt mean that perticular database will move to another instance of sql server. Mode of database is totally independent of server level clustering

    ----------
    Ashish

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply