Post reply

Recovery model options

  • May 15, 2006 at 10:17 am

    #637910

    Just do an ALTER DATABASE mydb SET RECOVERY SIMPLE.

  • May 15, 2006 at 2:57 pm

    #638016

    Graham,

    Have you considered leaving the dev and test databases in place and just refreshing the data using DTS?  You wouldn't have to worry about changing the owner.

    Greg 

    Greg

  • May 16, 2006 at 1:38 am

    #638071

    So does that mean that SQL Services do not need to be restarted?

    Graham

  • May 16, 2006 at 8:06 am

    #638156

    Graham

    Yes, it does mean that.

    John

  • May 16, 2006 at 8:06 am

    #638155

    You do not have to restart SQL after ALTER DATABASE.

    Have you looked at replication or log shipping?  Unless a large percentage of the production database has been modified from one day to the next, restoring the full backups every day is probably overkill.

  • May 16, 2006 at 8:15 am

    #638163

    We are looking at Log shipping now, the problem is that I have only just gotten the change over from SIMPLE to FULL recovery model.

    The full restore is a business requirement, so its one of those things.

    I thought moving of the physical file locations with the ALTER DATABASE statement required a restart of SQL Services?

    Thanks for the answers, has answered all my questions, much appreciated.

    Graham

Viewing 6 posts - 1 through 7 (of 7 total)

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