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

    Do we really need to stop the services? i guess once u detach a db, the mdf and ldfs will not be in use by sql server and hence u can move the files without restarting the services.



    Pradeep Singh