log_reuse_wait_desc in a 2000 database in 2005?

  • jpSQLDude (5/16/2011)


    Ninja's_RGR'us (5/16/2011)

    Well it doesn't <completely> break it. that's why I said I preffer to have that run with full backups as first and last steps.

    I'm pretty sure the instant you set your database to SIMPLE Recovery model with ALTER DATABASE [PROD] SET RECOVERY SIMPLE you just broke the log chain. No?

    Yes it does. In my case the whole script runs in less than 6 minutes (full backup included). So the break in the log chain is not an issue here.

    But I understand it can be for you or anybody else with slower disk subsystems.

Viewing post 16 (of 15 total)

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