August 20, 2014 at 1:07 am
hi all,
My windows server admin install a security patch on a windows 2008 R2 server.
KB 2982791
KB 2978668
KB 2976897
KB 2976627
KB 2937610
KB 2914357
Within the same box that's where my SQL server 2008 R2 database exist.
I am not sure did that windows OS security actually converted my database recover model from full to simple.
Cos the next day i received all my transaction logs backup failed (from backup exec software).
Is there such a things or anyone encounter such things before.
How do you guys assess the security patch? On whether it will create impact or make changes on anything?
August 20, 2014 at 11:29 am
A windows security patch shouldn't change the recovery model of a database.
I'd look in the default trace to see if it still has information about an alter database on the database(s) that are in question. It doesn't show the specific command, but should give you an idea. Hopefully it will still be there.
In my opinion, patches (windows and SQL Server) should be treated like any other changes and go through the change control process (dev, test, uat, and production).
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply