Can i know what is the max size of MS SQL server database in free tier?
And how can i scale it?
The max size for the free tier is 10MB. If you exceed the 10mb size, you have to switch to a paid plan ($5/mo). You can scale it from the control panel.