detail explanation on this querygreenspun.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
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