I was reviewing our SQL DB backups and noticed that the DB's marked for full recovery do not have any transaction logs. I am looking for a .trn file associated with the db and cannot find any. I thought these were necesaary in order to do a point in time recovery. Where is the default location of the transaction logs? I worked with a dba in hte past that used to get trn files every 15 minutes and would back them up hourly. How was this accomplished? My goal is to be able to back up a db and allow for recovery within 15 minutes of a failure. Any help doing this through SQL Management Studio would be great.