detach and attach

  • When you detach a DB and then rename the transaction log file so that it will create a new one (in the case where the xaction log file has grown huge) , Should I check the 'update statistics prior to detach' in order to make sure that any uncommitted transactions getting written to the DB? Also, do the DB options or recovery model have to be set a certain way in order for this to work properly?

    Thanks

  • When you detach, all transactions will complete or rollback. The update statistics is to ensure they are up to date before you detach.

  • Thank you!!!

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

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