If you can, you can use the standard 'BACKUP DATABASE' sql, though you'll have to write a script and schedule it manually. You can also use the sqlbackup command or whatever it is.<BR><BR>But ...

These steps do not represent an exhaustive list, but they are a good start to forming a sound database backup and recovery strategy.

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...