So for those of us who killed siad using task manager, does this mean we have also lost our coins and any uploads stored in new wallet? Hard to imagine that.
No you still have your coins : try deleting resources\app\Sia\consensus\*
or
- copy your resources\app\Sia\wallet\*
- start with a fresh install, but copy & paste the wallet directory and start the client.
Ok, Option 1 is the way to go!

All good!
Coin balance is correct and sitting at block 16448. password works fine, showing host etc.
Conclusion: If you corrupt your data base, delete consensus file, Kill siad (if running) restart wallet, let it fully sync up, then unlock wallet.
PS: I still don't see my file I had uploaded? not a biggy right now

Just not sure after closing wallet again if we should just let siad process stay running? oh well.
If you want to close the daemon remember to use siac stop not your task manager or you will be back to square one.