We recently had a few new servers installed at my workplace, and I am attempting to be the systems administrator and am trying to work on this problem. The vendor that installed our servers built a custom MS Access front end to work with a SQL server they setup and configured for us.
Well, after a couple months of running, all of a sudden the hard drive is full on the SQL server because of a specific Idf file that has grown to about 40GB. The programmer that wrote our software is not available right now and I need to do something about this ASAP. Our customer database is down until I can free up space on the hard drive. I've ran a complete virus scan on this server and nothing was found. The problem is coming from this one Idf file. I ran a search of all the files that have been modified since the day before this problem happened and only a handful showed up and aren't a concern.
What is this file, why has it grown so large, and what can I do to fix it (delete it)? I'm not familiar with SQL and would really appreciate some help.
Thanks,
Shawn F.
Well, after a couple months of running, all of a sudden the hard drive is full on the SQL server because of a specific Idf file that has grown to about 40GB. The programmer that wrote our software is not available right now and I need to do something about this ASAP. Our customer database is down until I can free up space on the hard drive. I've ran a complete virus scan on this server and nothing was found. The problem is coming from this one Idf file. I ran a search of all the files that have been modified since the day before this problem happened and only a handful showed up and aren't a concern.
What is this file, why has it grown so large, and what can I do to fix it (delete it)? I'm not familiar with SQL and would really appreciate some help.
Thanks,
Shawn F.