How to shutdown a database cleanly before stopping the service in order to copy mdf files

• Dean Jones-454305

  SSCarpal Tunnel

  Points: 4804

  More actions

  September 23, 2009 at 11:30 am

  #134102

  Hello Guys

  I am looking for a way to copy a replicated database files, if the SQL service is stopped and the files copied, there could be problems with ongoing transactions in the database, this will mean that when the database is about to be attached, it fails with an error.

  Is there a standard way to shutdown the database before stopping the service so that the files can be copied.

• Sergey Vavinskiy

  SSCarpal Tunnel

  Points: 4469

  More actions

  September 23, 2009 at 11:58 am

  #1057685

  1. Script your replication

  2. Disable replication

  3. Detach database

  4.Copy database files

  5. Attach your database

  6. Run your replication scripts from SSMS - your replication will be recreated.

  7. Go to the Replication agents properties and run your replication snapshot.