Is there any solution for growth the size of data and log file in SQL Server?

o0lyfsai 于 2023-10-15 发布在 SQL Server

关注(0)|答案(1)|浏览(139)

I can create a database in SQL Server using this SQL statement:

create database test on
[
    (
        [NAME= LogicalName, FILENAME= 'PhysicalName', 
        [,SIZE= Size] [,MAXSIZE= MaxSize | UNLIMITED]
        
    ) [,...n]

How to handle FILEGROWTH in this case?

I expect you to give me a solution with examples.

sql-server

来源：https://stackoverflow.com/questions/77194232/is-there-any-solution-for-growth-the-size-of-data-and-log-file-in-sql-server

1条答案

按热度按时间

2fjabf4q1#

I could find this solution

CREATE DATABASE DbName 
ON [ ( [NAME = LogicalName, 
        FILENAME = 'PhysicalName',  
        [,SIZE= Size] [,MAXSIZE= MaxSize | UNLIMITED] 
        [,FILEGROWTH= Growth] ) [,...n] 
        [LOG ON ( [NAME= LogicalName, FILENAME= 'PhysicalName',  [,SIZE= Size] [,MAXSIZE= MaxSize | UNLIMITED] [,FILEGROWTH= Growth] )[,...n] ]

赞(0）回复(0）举报 2023-10-15

我来回答

Is there any solution for growth the size of data and log file in SQL Server?

1条答案

相关问题

热门标签

最新问答