Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2003-03-24 : 22:47:23
|
| Hi,What is an non-logged operation ? And y is "TRUNCATE & SELECT * INTO" is a non logged operation ?Ne help is appreciated.RoyalSher.The world is the great gymnasium where we come to make ourselves strong. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-25 : 11:40:44
|
| What version of the product are we talking about? These operations are treated a bit different between 7.0 and 2000. 2000 logs the allocation/deallocation of extents, which is considered minimally logged.A non-logged operation is one that is not (individually) logged in the Transaction log. These are meant for very specific uses, such as truncating tables, select intos, and bulk operations. Truncate is non logged (Or minimally logged in 2000) for speed reasons. If you want to do the same and have it fully logged you can do a "delete from table". I would say the reason for most any non logged op is to give a speedier alternative to a very specific task.-Chad Edited by - chadmat on 03/25/2003 22:44:07 |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-25 : 12:03:37
|
quote:
I would say the reason for most any non logged op is to give a speedier alternative to a very specific task.
...at the cost of not being able to rollback said transaction.Jay White{0} |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-25 : 20:34:21
|
| No, you can rollback a truncate table, it simply reallocates the deallocated pages/extents. |
|
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-03-25 : 23:17:46
|
| Thanx to all for giving me the explanation.RoyalSher.The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
|
Non Logged operation