How do I manage the space of my SQL Server properly?
by Bryan Oliver
Q: My web hosting company has limited my SQL server size to 100 MB though the data there is only of 50 MB but what if the size keeps on increasing to 200 mb or something? How do I manage the space properly?
Bryan Oliver says: It sounds like your log file is growing or the tempdb if you are using a lot of calls to tembdb.
If you are seeing large log file growth you can put your database in simple mode or look at doing frequent log backups to reduce the amount of growth that occurs between backups.
Technorati Tags:
database growth, log file, tempdb
Share this post with friends
