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
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
Post a Comment