Thursday, August 19, 2004

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

Web Hosting Cheap PHP Plans Also at For free flags of the world