Sunday, July 8, 2012

Increasing the Size of SQL Server 2012 DB

USE master;
GO
ALTER DATABASE TestDb
MODIFY FILE
    (NAME = testdbdat,
    SIZE = 50MB);
GO
This command will increase the database TestDb data file to 50MB.

No comments: