Solved

DBCC command to expand a file

Posted on 2010-08-12
3
263 Views
Last Modified: 2012-05-10
like dbcc shrinkfile
is there a statement to expand a file.

I want the data file to be sized at 4 GB and not 3 GB, where it is at right now.

thanks
0
Comment
Question by:anushahanna
3 Comments
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 250 total points
ID: 33423534
You don't need a DBCC command to do that.  

You use ALTER DATABASE for that.
0
 
LVL 5

Assisted Solution

by:tvPrasad
tvPrasad earned 250 total points
ID: 33423680
Yes, you can use Alter Database with SIZE = 4GB option

0
 
LVL 6

Author Comment

by:anushahanna
ID: 33423687
Thanks.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now