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.
Showing posts with label Log Management. Show all posts
Showing posts with label Log Management. Show all posts
Tuesday, June 23, 2009
View Log Size and Space Used
Use the following command to see the current log size (MB) and space used for all Databases.
DBCC SQLPERF(LOGSPACE)
The output will be as follows
DBCC SQLPERF(LOGSPACE)
The output will be as follows
Subscribe to:
Posts (Atom)