InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 23:52:53 GMT20http://www.sqlservercentral.com/Forums/Topic409359-729-1.aspxI tried your method and it does not work - for example:USE ENTERPRISE_SERVERSGOEXEC master.dbo.sp_dboption 'ENTERPRISE_SERVERS','autoclose',trueGODECLARE @cmd VARCHAR(255)SET @cmd = 'copy C:\SQLDATA\ENTERPRISE_SERVERS.mdf "C:\BACKUPS\"'EXEC master.dbo.xp_cmdshell @cmdEXEC master.dbo.sp_dboption 'ENTERPRISE_SERVERS','autoclose',falseGO..................returns the folllowing error:The process cannot access the file because it is being used by another process............which defeats the purposeThu, 30 Jul 2009 06:15:19 GMTmsearnesthttp://www.sqlservercentral.com/Forums/Topic409359-729-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Backup+%2f+Restore/30292/">Take a Cold Backup without shutting down SQL.</A>[/B]Thu, 11 Oct 2007 01:06:33 GMTbodhayansharma