September 15, 2010 at 11:35 am
hi folks,
I have an issue.i need to change the size of the database.When its was given an intial size of 80gb but has the used space in MB.When i backup that database and restore on other box i see an error that my disk doesnot have enough space.but i have 40gb sitting overthere.If change the size of the databse and take a new backup over the second box.then i will have no issues...?
Can any one help me in changing the database size alloated to it at the time of creation?
September 15, 2010 at 4:41 pm
See DBCC SHRINKFILE
http://technet.microsoft.com/en-us/library/ms189493.aspx
Shrinking data files will cause index fragmentation and you will need to rebuild your indexes after the shrink.
September 15, 2010 at 4:45 pm
You could do as Edogg suggests.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply