Comprehensive data protection for all workloads
Post Reply
Rettep91
Novice
Posts: 8
Liked: never
Joined: Nov 16, 2017 1:44 pm
Full Name: Petter Roness Madshus
Contact:

Transaction log backup no data

Post by Rettep91 »

Hi,

I have an Application aware backup job of two SQL 2014 servers With transaction log backup every 15 min.
There are no errors on either job, but somehow the transaction logs on the SQL server keeps growing.
After further investigation i see that the transaction log backup reports successful backing up 0 bytes from 0 databases.

All db permission has been given to the backup user in SQL, even sysadmin, and i cant find the suggested guesthelper Log error message in KB ID 2447.

Any ideas?

Regards
Rettep91
Dima P.
Product Manager
Posts: 14417
Liked: 1576 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Transaction log backup no data

Post by Dima P. » 1 person likes this post

Hello Rettep91.

Please open a case and check with support team if the solution provided in KB article does not work. Do not forget to include case ID in this thread for future reference. Thank you.
Rettep91
Novice
Posts: 8
Liked: never
Joined: Nov 16, 2017 1:44 pm
Full Name: Petter Roness Madshus
Contact:

Re: Transaction log backup no data

Post by Rettep91 »

Hi again,

It now seems to work and it was the changes in the KB article that did the trick. It seems that we had not performed a new full backup so the changes hadn't taken effect yet, but after running the full backup again the log backup started crunching data :)

Thanks for the quick response.
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 72 guests