detail explanation on this query

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi Eric,

backup log dbname with truncate_only

Give me detailed explanation on the above sql query.

-- Anonymous, May 26, 2003

Answers

Raja,

backup log dbname with truncate_only

Removes the inactive part of the log without making a backup copy of it and truncates the log. This option frees space. Specifying a backup device is unnecessary because the log backup is not saved. After backing up the log using TRUNCATE_ONLY, the changes recorded in the log are not recoverable. For recovery purposes, immediately execute BACKUP DATABASE.

Hope this helps,

Eric

-- Anonymous, June 02, 2003


Moderation questions? read the FAQ