<< Using SQL Server Management Studio >>
To increase the size of a database:
- In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
- Expand Databases, right-click the database to increase, and then click Properties.
- In Database Properties, select the Files page.
- To increase the size of an existing file, increase the value in the Initial Size (MB) column for the file. You must increase the size of the database by at least 1 megabyte.
- To increase the size of the database by adding a new file, click Add and then enter the values for the new file.
- Click OK.
<< Using Transact-SQL >>
To increase the size of a database:
- Connect to the Database Engine.
- From the Standard bar, click New Query.
- Copy and paste the following example into the query window and click Execute. This example increases the size of the file test1dat3.
Transact-SQL
USE master;
GO
ALTER DATABASE AdventureWorks2012
MODIFY FILE
(NAME = test1dat3,
SIZE = 20MB);
GO
Reference:
Increase the Size of a Database
http://msdn.microsoft.com/en-us/library/ms175890.aspx
No comments:
Post a Comment