In keeping with his SQL Server and PHP theme, Brian Swan has another new post talking about the combination, but this time he focuses on using the SQL Server driver for PHP to backup and restore a database with the BACKUP and RESTORE SQL Server commands.
The strategy you choose really depends on your application and your data. [...] Since I canâ€™t possibly cover everything between those extremes in one post, Iâ€™ll aim for something in the middle. Like a blog, perhaps. In other words, Iâ€™ll address the scenario in which I donâ€™t want to lose data, but Iâ€™m not willing to go to extremes to preserve it.
The post is largely SQL Server related - mostly for the BACKUP and RESTORE - but it gives you a good idea of how to make a full backup, take a snapshot of your logs and restoring that information back up just in case.