Jump to content
Sign in to follow this  
sdube

Uses of journal backup (truncate or not)

Recommended Posts

Hi,

 

Could someone explains to me what is the use of the "journal" options for SQL server?

What I am doing right now is doing a full backup every month and differential backups every day. Is the journal backup useful? Does the journal backup also backups structural changes on the server? If not, then I might only use the differential backup...

 

Thank you.

 

Share this post


Link to post
Share on other sites

I wouldn't go that long doing nothing but differentials. A week tops is my thought, with every day being ideal. SQL restores using diffs and log-truncates can be tricky if they're strung out to long, and it can take a considerable amount of time to roll back a month of transactions.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×