trying to decrease the size of the trans log for a sql7 db. In sql 2000 the dbcc shrinkfile seems to actually descrease the size of the file when run after using the truncate log, but in sql7 running that same command does not seem to descrease the physical size of the file on the hard drive.
Is there a way in sql7 to descrease the physical size of the log file(or data file for that matter)?
thanks,
Todd
Is there a way in sql7 to descrease the physical size of the log file(or data file for that matter)?
thanks,
Todd