![]() Percentage, while in both cases we must define the value in MB format. It leaves us with two options either by specific absolute value or by In a way we define the FILEGROWTH parameter. How fast a databaseįile can reach its maximum space can be resolved using the FILEGROWTH parameter. Space can be occupied by a database can be defined using the MAXSIZE parameter. ![]() The initial size will be the same as the model database if by chance user forgot to define the initial size parameter while creating a database or do the same intentionally.Īt the beginning, size of the database can be set up using the SIZE parameter and how much maximum While creating a database initial size of the database files (Dataįile and Log File) can be defined by us, with the Autogrowth and MAXSIZE In this article, we will discuss the actual database file size and free space in the database file size with the help of monitoring script and shrink solutions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |