开发者

Turn off MS SQL Server logging

开发者 https://www.devze.com 2023-03-09 21:33 出处:网络
I know that it is impossible to turn off the transaction logging in Microsoft SQL ServerBut my boss wants an official evidence ab开发者_Go百科out this

I know that it is impossible to turn off the transaction logging in Microsoft SQL Server

But my boss wants an official evidence ab开发者_Go百科out this

And I cannot find that

Please help me to find official information (preferably on MSDN) about impossibility of turning off the transaction logging in Microsoft SQL Server

Thanks


MS KB 873235

End of first paragraph under "More information about transaction log files" states:

Because the transactional integrity is considered a fundamental and intrinsic characteristic of SQL Server, logging the details of the transactions cannot be turned off in SQL Server.

I'd consider your position if your boss doesn't trust your techincal expertise and judgements


I dont believe you can, nearest would be to use the simple recovery mode where once the transactions been successful the item is marked for deleting, ergo keeps the transaction log as near to small as possible.

0

精彩评论

暂无评论...
验证码 换一张
取 消