MS SQL

Databases with MAXSIZE Set

  • Article

Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When the database grows to the MAXSIZE the database will not grow anymore and if someone tries to add more rows they will get an error saying the database is full.

2018-06-19

2,410 reads

Blogs

Recover database encrypted modules code with dbatools

By

This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments...

Azure SQL Offers Manual Failover for PaaS Resources

By

Sometime having the right command in place opens up new doors to test things,...

Azure SQL Offers Manual Failover for PaaS Resources

By

Sometime having the right command in place opens up new doors to test things,...

Read the latest Blogs

Forums

SSRS Query Designer not showing newly added measures

By sherrilmcdonald

We have recently added new measures to our existing cube in dev and test....

Cannot restore DB using T-SQL script

By jbeclapez

Hello, I had a database called Training_01 and did a backup of it. It...

Transaction log used space

By everand

It's a little weird for me. I have a database (AdventureWorks2014; SQL Server 2014)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers