Take a Cold Backup without shutting down SQL.

• bodhayansharma

  SSC Enthusiast

  Points: 138

  More actions

  October 11, 2007 at 1:06 am

  #375615

  Comments posted to this topic are about the item Take a Cold Backup without shutting down SQL.

• msearnest

  Newbie

  Points: 9

  More actions

  July 30, 2009 at 6:15 am

  #1032325

  I tried your method and it does not work - for example:

  USE ENTERPRISE_SERVERS

  GO

  EXEC master.dbo.sp_dboption 'ENTERPRISE_SERVERS','autoclose',true

  GO

  DECLARE @cmd VARCHAR(255)

  SET @cmd = 'copy C:\SQLDATA\ENTERPRISE_SERVERS.mdf "C:\BACKUPS\"'

  EXEC master.dbo.xp_cmdshell @cmd

  EXEC master.dbo.sp_dboption 'ENTERPRISE_SERVERS','autoclose',false

  GO

  ..................returns the folllowing error:

  The process cannot access the file because it is being used by another process.

  ...........which defeats the purpose