View Full Version : Backup Transaction Logs


AnnPhil
08-22-2010, 07:13 AM
I am using SQL Server 2005 Management Studio to create a maintenace plan for my database. When I get to the part where you set up the back up of the transaction logs and i select specific databases, it only gives me one of two choices; all users databases or model database. I have tried both ways but after the backup is performed all i see are the .bak files. I believe the transaction files are .trn according to the backup wizard. The backup location is the same for both database files and transaction files so i don't know why the transaction backup files are not there.

Thanks in advance for any help!

SQL_Hell
08-27-2010, 08:20 AM
It should give you a list of the databases you want to backup the transaction logs for, which you can tick the right ones.

If it's not listing the databases, you either have a permissions issue or you are connected to the wrong server / instance.

Some screen shots might help