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:
You may need to run the