I am attempting to configure a MSSQL 2005 Express db to flush its in memory data to disk so that the data can be captured by using disk snapshot software. I have been unable to find any particular way to accomplish this through any tools currently available for MSSQL Express. My option up to this point has been to shut the MSSQL service down, take the snapshot, and then restart the service. I would like to not have to dump the database out to a file, as this would defeat the purpose of taking a disk snapshot.
Does anyone know of a way to force MSSQL Express to flush its in memory data to disk, or is stopping and restarting the service the best course of action?