Turn off MS SQL Server logging
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 thatPlease 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.
精彩评论