Hello Sir, Daily i am taking backup. I am storing the log backup also in same database folder. I have to know whether i can shrink the log file after taking database backup without backing up the log file of that database.What is need of taking log backup after taking database backup safely.

Regards, Raja V

-- Anonymous, April 17, 2003

Answers

Raja,

When restoring a database, you can restore it to the state of the last database backup, or the state of the last database backup plus the subsequent logs.

Generally, therefore, the log files are necessary to restore a databse to the point of failure.

The log is truncated at the completion of a BACKUP LOG statement. This is automatic and safe. However, manually truncating the log after the database backup would would delete the record of any transactions between the database backup and the log truncation.

Hope this explains the situation,

Eric

-- Anonymous, April 19, 2003