更新后的Windows 2016 SQL Server STD将恢复为较旧的还原点 [英] Windows 2016 SQL Server STD after update reverts back to older restore point

问题描述

大家好，

Hi All,

我希望你能提供帮助，我我的SQL服务器2016 VM（标准版）确实存在问题，当我执行Windows更新并重新启动VM时，它会以某种方式将数据库恢复为一个多月前的版本。因此，我必须在任何人向"旧版本"写入任何内容之前快速恢复备份
db。数据库。这很生气！ 

I hope you can help, I'm having a real problem with my SQL server 2016 VM (standard), when i do the windows update and restart the VM it somehow reverts the database's back to a version from over a month ago. So i have to quickly restore the backup db before anyone writes anything to the "Old version" of the db. which is mad! 

我在事件日志中看不到任何内容，表明问题是什么并且它不会发生我拥有的任何其他服务器 - 它真正令人头疼！

I dont see anything in the event logs to indicate what the issue is and it doesnt happen any other server i have - its a real head scratcher!

任何人都有想法？

干杯

Daniel

推荐答案

在我看来这是VM设置而不是SQL Server的问题，其中图像在重新启动后恢复。请咨询您的虚拟化团队，了解他们是否可以提供意见。

It seems to me this is an issue with the VM settings rather than SQL Server, where the image gets reverted after a restart. Check with your virtualization team to see if they can provide input.

这篇关于更新后的Windows 2016 SQL Server STD将恢复为较旧的还原点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！