I have an old SharePoint installation that is no longer in use (SP has been upgraded and moved to another server). I'd like to turn off this SharePoint 2007 install for a while so that it's not writing log files to the SQL server. Can I simply turn off some of the services to do this rather than uninstall SharePoint?
There are a few ways to do this, depending on what kind of user experience you need.
If the users still need to be able to access content, you can simply mark all of the SharePoint related databases to Read-only in SQL. (assuming your installation is at least Service Pack 1)
If your users no longer need to see the data at all, you have a few options.
The largest source of data being written to SQL usually comes from Search Indexing, so if all of these options seem too drastic, you can peel back the frequent activities.