troubleshooting Question

SQL 2005 Transaction Logs

Avatar of NytroZ
NytroZFlag for United States of America asked on
Microsoft SQL Server
8 Comments1 Solution440 ViewsLast Modified:
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.
Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros