December 24, 2007 at 7:19 am
there is no diskspace in log volume(K)..when i gave the command
DBCC SHRINKDATABASE('DMP')
The log file for database 'DMP' is full. Back up the transaction log for the database to free up some log space.
HOW i can make space?
December 24, 2007 at 9:52 am
If you don't have space to do a backup of the log, you can truncate it with this:
BACKUP LOG DMP WITH TRUNCATE_ONLY
then you can shrink the database. After all this, you must do a complete backup.
December 24, 2007 at 10:01 am
Shrink the files, and then be sure that you are backing up the log periodically. A database backup is not enough.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply