Backup Transaction Logs (1 Viewer)

[AnnPhil]

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]

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