CODEWITHSUNDEEP
sql-serversql-server-2005sql-server-2008
Oleg Kalenchuk
Oleg Kalenchuk

Reputation: 517

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 about 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

Upvotes: 1

Views: 8227

Answers (2)

gbn
gbn

Reputation: 432662

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

Upvotes: 8

BugFinder
BugFinder

Reputation: 17868

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.

Upvotes: 0

Related Questions