I have a server with two partitions C and D. All software packages are installed on C drive and D is used for database storage for a SQL database. What happens if my database in D drive fill up 100% (while im not near the computer to do anything about it). Will it crash the whole computer or will it just stop adding new data?
Your computer shouldn't crash, but performance is going to decreases for sure when that partition fills up. Just make sure you never run out of space haha
It'll either erase the oldest data to make space for the newest data or it'll stop updating the database. The latter is more likely to occur
but the computer itself won't crash right? I'm mainly wondering whether the software packages running on C are going to run as before (since my database is on a secondary hard drive)
I've used computers for a long time - professionally and personally - and I have to admit I am a little stumped by your question! The drive that has filled up will stop adding data, but the programs on your C drive should work fine, I think. You might notice a decline in performance, though.