Insert and Updates without Logging
-
We have a smaller development box and want to do some testing on future data changes. Can Insert and Update statments be run without logging them?
(I was hoping to not have to change the log size or truncate on Checkpoint)
Thanks
(we just changed the db to Simple and ran Checkpoint between each action - sorry for wasting your time...)
I wasn't born stupid - I had to study.
-
No, you can't stop them from being logged. They are necessary to ensure the system's ACID properties. However, you change can your recovery model to simple, as you already did and in case of INSERT maybe you bcp or BULK INSERT. That way the operation is only minimally logged.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thanks - I kinda wish I could delete my posting so I do not waste people's time when I figure out an approach.
Your URL is in German. Do you know of an American equivalent?
I wasn't born stupid - I had to study.
-
No, I don't think any question here is a waste at all !!!
Sure, my site is German since I am from Germany.
As for equivalent, I guess you've found it here. But this site is much, much bigger and intended for a global audience, while mine is narrowed due to the language. However you might want to dig through my link library of other SQL Server sites worth visiting: http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/catid,1/
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply