After large operations on the database the Log file may get filled and you may get a warning that there is no space to execute the SQL Command.
Use the following command to clear the Log File.
DBCC SHRINKFILE(LogFileName, 1)
You can get the name of the Log File with the following command
sp_helpdb databasename
DBCC SHRINKFILE is an interesting command and can also be used to shrink the Data files. Read the following MSDN article to more about this command.
No comments:
Post a Comment