sql tying up hard drive

[jeromekjerome]

I am maintaining a very large reference database on my laptop using ms sql developer. As the database has gotten large, ms sql insists on completely occupying my disk i/o for 30 minutes or so at a time, several times a day. The only way to get anything done is to stop the server involved.

What's going on here? Is ms sql maintaining some kind of performance tables or something? Is there any way to schedule it or simply turn it off since I am the only and infrequent user?

 

[SonOfEmidec1100]

Have a look at the database properties/options, if [blue]auto shrink[/blue] is selected turn it off and see if that helps. Or experiment with turning the other Auto options off.

 

[timscronin]

On the dboptions also see what the property is for the database backup method. You will want to see simple, if not and you have not backed up the trans log it will grow and grow and grow

 

[jeromekjerome]

Thank you both so much for your help. I turned off auto shrink and the problem seems to have gone away. I will also check back up options. Thanks again.