October 19, 2016 at 12:36 pm
We had a weird incident last night where five databases had nulled owners. In other words, if you ran sp_helpdb you would see null in these five databases instead of sa who own most of our databases. All the jobs started failing ,etc. This was NOT anything any of us did, and I cannot imagine what would cause it? Any suggestions?
This is Sql Server 2012 sitting on top of Win 7 Enterprise.
October 19, 2016 at 5:04 pm
CM-249617 (10/19/2016)
We had a weird incident last night where five databases had nulled owners. In other words, if you ran sp_helpdb you would see null in these five databases instead of sa who own most of our databases. All the jobs started failing ,etc. This was NOT anything any of us did, and I cannot imagine what would cause it? Any suggestions?This is Sql Server 2012 sitting on top of Win 7 Enterprise.
Could they have been owned by someone who left the company, a Windows account that has recently removed or a login that has been dropped? Something along those lines is usually the case.
Sue
October 19, 2016 at 6:27 pm
Sue_H (10/19/2016)
CM-249617 (10/19/2016)
We had a weird incident last night where five databases had nulled owners. In other words, if you ran sp_helpdb you would see null in these five databases instead of sa who own most of our databases. All the jobs started failing ,etc. This was NOT anything any of us did, and I cannot imagine what would cause it? Any suggestions?This is Sql Server 2012 sitting on top of Win 7 Enterprise.
Could they have been owned by someone who left the company, a Windows account that has recently removed or a login that has been dropped? Something along those lines is usually the case.
Sue
Extremely unlikely as this server was migrated 2-3 year ago. We would have noticed during migration any weird accounts.
October 20, 2016 at 4:01 am
CM-249617 (10/19/2016)
Sue_H (10/19/2016)
CM-249617 (10/19/2016)
We had a weird incident last night where five databases had nulled owners. In other words, if you ran sp_helpdb you would see null in these five databases instead of sa who own most of our databases. All the jobs started failing ,etc. This was NOT anything any of us did, and I cannot imagine what would cause it? Any suggestions?This is Sql Server 2012 sitting on top of Win 7 Enterprise.
Could they have been owned by someone who left the company, a Windows account that has recently removed or a login that has been dropped? Something along those lines is usually the case.
Sue
Extremely unlikely as this server was migrated 2-3 year ago. We would have noticed during migration any weird accounts.
was it the same account that owned all 5 databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply