I have a sql server running on a desktop and it has used up the disk space on C. I dont have historical data in the tables. SQL is used to process text files to then be loaded into TM1. All I need is the tables,views structure,etc. As a drastic measure, can I stop the service, delete the Database and its log files and recreate the tables and views with the same names and restart the service? will that reduce the log files to 0? I plan to do a regular back up of the log files after that.
You would be better to carry out the following process:
- Set the database logging mode to simple
- Set the 'auto shrink' database option
- Shrink the log file with
DBCC SHRINKFILE(2, 256)
NB: this assumes your log file is file number 2 (which is typically the case).
You may need to run the
DBCC command a couple of times to have the desired effect.