Koen Verbeeck (3/8/2011)
GilaMonster (3/8/2011)
Koen Verbeeck (3/8/2011)
If a data load fails, the destination table can be truncated and the load can start over again, so you would not have to worry about inconsistency.What would happen if the server failed at the point SQL was modifying the allocation constructs or system tables in the database and there was no logging? Not so easy to fix.
Logging is not just for the user data. It's for page allocations, allocation page modifications, system table modifications and a while lot more.
As BI developer I can only say the following thing:
Oink?
😀
I guess you're right. As ETL developer I only think about moving data, not so much about the features you just described...
Exactly. I suspect most people asking for no logging don't think about the system/structure changes that get logged. If a load were to fail part way through, it would not be a case just of truncating the destination table and starting again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability