Setting the autoclose option on an SQL database causes the SQL server to in effect detatch from the MDF datafile as soon as the last user closes their dataconnection.Setting this option has the advantage that when the DB is not in use the MDF and LDF files can simply be copied from one server to another with no further requirementUse the following syntax to change the option use mastergosp_dboption <databasename>, autoclose, "on" 

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_8c32.asp for full details of the sp_dboption procedure