I had an hosted SQL Server Database, the hosting company had an limit of 200 MB for each db.
Then I moved to another hosting company which had virtually no such limit.
I backed up database and restored to new hosting.
After few days, my database crossed 200MB and all my queries were failing.
I noticed the database still had limit of 200MB,
Changing the limit via Management Stuido did not help ( as it was not showing up the File Option )
So here is the statement which helped me.
ALTER DATABASE [dbName] MODIFY FILE ( NAME = N’DB_Name_data’, MAXSIZE = UNLIMITED)
Very nice article and straight to the point. I am not sure if this is in fact the best place to ask but do you guys have any thoughts on where to hire some professional DBA? Thank you 🙂
This article will help the internet users for creating new web site and resolving issue with SQL Server
I have read some good stuff here. Certainly worth bookmarking for revisiting. I surprise how much effort you put to make such a fantastic informative web site.
Hello there! Would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would really appreciate your content. Please let me know. Many thanks