How to Open a Microsoft SQL Server .Bak File. You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file ...

If the transaction log and database are in the same device you can't do a transaction log dump. In this case you need do a Truncate Log on Checkpoint. You also can't dump the log if the Select ...