December 30, 2008 at 10:16 am
nazaninahmady_sh (12/23/2008)
sorry what do you mean by non-logged operation?
every action you perfom that changes data or structure of your database is first written to the log file (There are two types of files associated with your database. 1. datafiles- containing actual data, 2. logfiles - all changes to your database are written to log files).
You use logs to recover from a database crash in conjuction with a full backup file.
non-logged operation is something where changes are not logged into the log files.
Minimally logged operation is something where minimum amount of information is written to the log files that is sufficient enough to recover from a crash.
What Gail tried to explain here is DELETE is a fully logged operation where as TRUNCATE is a minimally logged operation.
Full logging and minimal logging also depends on the recovery model that you've set for you database.
February 24, 2009 at 8:49 am
sure according to what u said it seems as if you do not really care about the data for now, you can also consider scripting your table as is and drop the table and recreate with your added columns or modifications however this depends on whether you needs the data or your application is dependent on the table as well.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply