Check out this WSS Feature that performs automatic backups of SharePoint sites upon their deletion: http://www.codeplex.com/governance. Handy. From a developer's perspective, I doubt I'd use this myself, but I can't count the number of times a user has asked me if it is possible to restore a site they've accidentally deleted. You don't get this functionality out-of-the-box with WSS 2.0/3.0, but this feature makes it possible.
All deletions and backups are logged to a folder of your choice and specific information such as the logged in user, deleted site, etc are all logged. SQL backups are created and sites can be restored with standard STSADM.EXE operations (-restore for site collections and -import for sub sites).
tags: sharepoint backup delete wss