SQL Server databases should be protected on a scheduled basis. A SQL database actually consists of two files; the database file (*.mdf) and a transaction log file (*.ldf). These files must match exactly for a backup copy of the database to restore properly. more at http://databasenews24x7.blogspot.com/2009/05/protect-your-sql-server-databases.html
