reduce the size of the log files in sql server2000
in the query analyser run
DBCC SHRINKFILE(SSPLM1_log, 2) here SSPLM1_log is the name of the log file while 2 is the intended size of the file after running the same.

to delete the unnecessary logs then
BACKUP LOG SSPLM WITH TRUNCATE_ONLY

Comments

Popular Posts