Home Forums SQL Server 2005 Backups Deattach or take offline the DB to copy RE: Deattach or take offline the DB to copy

  • tushaar.kudalkar (7/27/2009)


    Hi

    U need to stop the server services or else u will not be able to move ur .mdf and .ldf files

    This is not true. The only time you would need to do ths is if there are jobs that will access this database. And, if that is true, you will only need to stop and disable the affected jobs. Stopping the service is overkill.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/