Post reply

Take Off Line - 10 hours and still not complete

  • March 23, 2011 at 2:51 am

    #233757

    Hi all,

    So we have a 2005 box that runs are email archive system. All system dbs and user dbs are on the C drive. We have put in a new 1tb disks to move data off as this is an "important system".

    When i tried to take it off line with the GUI i waited 2 hours then decided there must be a problem so cancelled and tried the T-SQL way. i then fell a sleep waiting for it to drop with the idea of finishing when i woke up (Honest)..

    Woke up to see its 10 hours and still not done!

    This is only a 25gb file at present, so surely cant take that long?!

    Any ideas? Or is it a case of The system is just that slow so i need to find a very large window???

    Thanks

    S

  • March 23, 2011 at 3:00 am

    #1302328

    A take offline should be near-instantaneous, but it does need an exclusive database lock, which means it has to wait until all connections to the DB are closed.

    Either manually kill any connections to the DB, ask the people with those connections to close them or add the WITH ROLLBACK IMMEDIATE to the alter database to immediately kill all connections automatically

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 23, 2011 at 8:10 am

    #1302479

    Thanks Gilamonster!

    yes i moved another db a few months ago and did what you suggested. Im moving an apps DB so followed there instructions (even pointed out to guy in office i had another step :/)

    Shall give that a go tonight!

    Thanks

    Stephen

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

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