Transaction log questions

Talk about anything you want in here!

Posts: 19
Joined: Sat Mar 09, 2019 8:50 am
PostPosted: Thu Dec 03, 2020 12:13 pm
Hi there,

I have a small inhouse records program that uses a SQL DB. That DB is in Full Recovery Mode.

The DB is backed up nightly with this scheduled command from SQL Server Agent:-

BACKUP DATABASE [db1] TO DISK = N'C:\Db1 Backups\db1.bak' WITH INIT , NOUNLOAD , NAME = N'db1 backup', NOSKIP , STATS = 10, NOFORMAT

The transaction log is quite large, and it looks like no log backups have ever been run.

If I set up transaction log backups, can I write them out to the same file as above, or doe it need it's own filenames.

Can I delete the transaction log backups once the next Full DB backup has been run? If not, why not, and how long should I keep them?

Thanks for your time looking at these beginner questions!

Posts: 27
Joined: Mon Jul 15, 2019 12:39 pm
PostPosted: Thu Dec 10, 2020 5:45 pm
Hello!
I would suggest first you understand the basic concept of SQL Server Transaction Log Architecture and Management Guide on SQL Server Doc. Recently I was to use the services of Devart company. They bring me many solutions :) That was a DBForge's robust tool for reading transaction log. Work well!

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests

cron