Technical Article

Take a Cold Backup without shutting down SQL.

,

Set the Autoclose database option to True and perform a cold backup of your data files without even shutting down the SQL Server Services.

sp_dboption 'database_name','autoclose',true
or
sp_dboption 'database_name','offline',true

copy the datafiles to your backup folder....

sp_dboption 'database_name','autoclose',false
or
sp_dboption 'database_name','offline',false

Read 1,489 times
(7 in last 30 days)

Rate

2.67 (3)

You rated this post out of 5. Change rating

Share

Share

Rate

2.67 (3)

You rated this post out of 5. Change rating