March 23, 2017 at 5:01 am
One of my customers has a database in Full Recovery Mode. When making a backup of the transaction log, SQL Server gives an error telling me that it can't be done in Simple mode.
It's the only database with this problem. The other make backups of the logs without problems.
I've compared the properties of these databases with the one with the problem, but there are no differences apart from the collation that's slightly different.
Anyone an idea of how to solve this?
March 23, 2017 at 5:18 am
March 23, 2017 at 6:35 am
BrainDonor - Thursday, March 23, 2017 5:18 AMIf the database has been altered from Simple to Full Recovery recently it will look like it is in Full Recovery but requires a full backup before it is truly in Full recovery.
Has it been altered from Simple to Full and not had a Full Backup since?
a differential backup may also be used to start the log chain
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2017 at 3:49 pm
No thats not the casr. A full backup has been made firdst.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply