Is there anyway in SQL to backup the Database and Transaction log without truncte the Transaction log? . I would like to keep all or as much of the Transaction log info as possable. I know the Trans log will get large but HD space is not a problem. I use the transaction log to report field changes usung Log Explorer.
Ruprect, thats were I run into trouble. I make a complete back using SQL and Log Explorer says there is no LOG to be used. There is just a database and only a few transaction in the log. I'm using FULL recovery on the Database.
I backup the database daily with Backup Exec and SQL Database Maintenance. Just the database, they don't create any checkpoint or truncate the Trans Log.
What would be the best route in backing up the trans log for use with Log Explorer?