What should you do?

Your network contains a server that has Microsoft SharePoint Foundation 2010 installed.
You discover that the SharePoint database has a large amount of unused space.
You need to reduce the amount of unused space in the database.
What should you do?

Your network contains a server that has Microsoft SharePoint Foundation 2010 installed.
You discover that the SharePoint database has a large amount of unused space.
You need to reduce the amount of unused space in the database.
What should you do?

A.
From Central Administration, run the farm configuration wizard.

B.
From Microsoft SQL Server Management Studio, use the Object Explorer.

C.
From the SharePoint 2010 Management Shell, run the Set-SPContentDatabase cmdlet.

D.
At the command prompt, run the stsadm.exe command and specify the mergecontentdbs parameter.

Explanation:
How to: Shrink a Database
This topic describes how to shrink a database by using Object Explorer in SQL Server Management Studio. The database cannot be made smaller than the minimum size of the database. The minimum size is the size specified when the database was originally created, or the last explicit size set by using a file-size-changing operation, such as DBCC SHRINKFILE. For example, if a database was originally created with a size of 10 MB and grew to 100 MB, the smallest size the database could be reduced to is 10 MB, even if all the data in the database has been deleted.
To shrink a database
1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. Expand Databases, and then right-click the database that you want to shrink.
3. Point to Tasks, point to Shrink, and then click Database.
4. Optionally, select the Reorganize files before releasing unused space check box. If selected, a value must be specified for Maximum free space in files after shrinking.
Selecting this option is the same as specifying a target_percent value when executing DBCC SHRINKDATABASE. Clearing this option is the same as executing DBCC SHRINKDATABASE using the TRUNCATEONLY option. TRUNCATEONLY shrinks the file to the last allocated extent. This reduces the file size without moving any data. By default, the option is cleared.
5. Enter the maximum percentage of free space to be left in the database files after the database has been shrunk. Permissible values are between 0 and 99. This option is only available when Reorganize files before releasing unused space is selected.
6. Click OK.
Source: http://technet.microsoft.com/en-us/library/ms189035.aspx



Leave a Reply 52

Your email address will not be published. Required fields are marked *


Vickie Gerstner

Vickie Gerstner

My favorite city out of all I’ve been to, no doubt about it that its St Gallen Switzerland. Switzerland just has this nice connotation about it. Something I absolutely love, it is peacefull and comforting.

http://gusillham.livejournal.com/

Reta Poaipuni

Reta Poaipuni

Aw, this was an exceptionally nice post. In concept I would like to place in writing such as this moreover – spending time and actual effort to create a excellent article… but so what can I say… I procrastinate alot through no indicates find a way to go completed.

https://justpaste.it/zfn7

Carlo Quihuiz

Carlo Quihuiz

Undeniably believe that which you stated. Your favorite justification seemed to be on the web the simplest thing to be aware of. I say to you, I definitely get irked while people consider worries that they plainly don’t know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side-effects , people could take a signal. Will probably be back to get more. Thanks xrumer

http://www.scoop.it/t/click-link-15

Syreeta Flye

Syreeta Flye

Hey there, I think your blog might be having browser compatibility issues. When I look at your website in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, superb blog!

https://ucillaustin.wordpress.com/

Carlo Quihuiz

Carlo Quihuiz

Hiya, I simply hopped over on your web page via StumbleUpon. No longer one thing I’d usually learn, but I liked your thoughts none the less. Thanks for making something value reading.

https://www.diigo.com/user/evelinaausb

Mozella Mierzejewski

Mozella Mierzejewski

There are some fascinating points in time in this article however I don’t know if I see all of them middle to heart. There’s some validity but I will take maintain opinion till I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as nicely

https://app.box.com/s/xjjovntynhn7xikykqi4w367ua0m3fqs

Anjelica Bacher

Anjelica Bacher

I’d been just browsing every now and then but happened to be to learn to read this post. I must say that i’m within the hand of luck today in any other case getting such an excellent post to learn to read wouldn’t are actually achievable personally, no less than. Really appreciate your articles.

http://www.inmethod.com/forum/user/editDone/58993.page

Emmitt Costagliola

Emmitt Costagliola

When I originally commented I clicked the -Notify me when new surveys are added- checkbox and today each time a comment is added I buy four emails concentrating on the same comment. Is there in any manner you are able to eliminate me from that service? Thanks!

https://app.box.com/s/ppvhvs26qy3yczqzx1dbl6z7i87f9p7b

Theola Kadow

Theola Kadow

An intriguing discussion will probably be worth comment. There’s no doubt that that you simply write regarding this topic, it will not certainly be a taboo subject but usually consumers are not enough to communicate on such topics. An additional. Cheers

http://thehot.me/how-to-be-beautiful/

Thomasina Randklev

Thomasina Randklev

Can I merely say thats a relief to uncover someone who actually knows what theyre dealing with over the internet. You definitely discover how to bring a worry to light and work out it critical. Lots more people must ought to see this and can see this side on the story. I cant believe youre no more common simply because you certainly contain the gift.

http://thehot.me/beauty-is-everywhere/

Kathyrn Serva

Kathyrn Serva

Hello, i believe that i saw you visited my web site so i came to “return the prefer”.I’m attempting to to find things to improve my web site!I guess its adequate to use a few of your ideas!!

http://thehot.me/how-to-be-beautiful/

Tommie Cayabyab

Tommie Cayabyab

Aw, i thought this was a very good post. In notion I would like to put in writing like that additionally – taking time and actual effort to manufacture a excellent article… but what / things I say… I procrastinate alot and no indicates apparently get something accomplished.

http://thehot.me/how-to-be-beautiful/

Lauren Tocci

Lauren Tocci

The the next occasion I just read a blog, Hopefully who’s doesnt disappoint me just as much as this place. I mean, I know it was my method to read, but I just thought youd have something interesting to express. All I hear is actually a lot of whining about something you could fix in the event you werent too busy trying to find attention.

http://thehot.me/transforming-your-skin/

Clark Pendill

Clark Pendill

Hey, – Gulvafslibning | Kurt Gulvmand is a tremendously helpful post! Funny, I came over just to make sure I hadn’t missed anything and I come across a really worthwhile post

http://thehot.me/transforming-your-skin/

Kenyetta Becvar

Kenyetta Becvar

My personal sis recommended me personally about your own internet website and exactly how excellent it really is. She’s correct, I’m really impressed with the writing and clever design. It appears in my experience you are merely itching the surface when it comes to what you might achieve, nevertheless you’re on a good begin!

http://thehot.me/how-to-be-beautiful/

Ricky Krnach

Ricky Krnach

Why It Must be Panama for Dental Surgery? The factors for obtaining your dental surgical procedure accomplished in Panama are numerous, like: Most of your training dental surgeons in Panama speak English Panama has exceptional arrangements for diagnosing, screening and providers. There is no shortage of USA-trained doctors It costs far less to have your surgery carried out in Panama than in US or any other Western nation US dollar can be utilized And above all, your postoperative care is complimented by a visit on the pure beaches and pure forests of Panama.

http://thehot.me/how-to-be-beautiful/

Ward Estep

Ward Estep

An impressive share, I just given this onto a colleague who was doing a bit of analysis on this. And he in truth purchased me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the treat! However yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love studying extra on this topic. If possible, as you develop into expertise, would you thoughts updating your blog with more details? It is highly helpful for me. Huge thumb up for this blog post!

http://thehot.me/beauty-is-everywhere/

Sherryl Howle

Sherryl Howle

Search engine marketing wants a superb search engine optimizer plan. Just certainly one of these strategies can make a big distinction in your sites position and firm your website brings you.

http://thehot.me/beauty-is-everywhere/

Luther Tope

Luther Tope

When I originally commented I clicked the -Notify me when new surveys are added- checkbox now when a comment is added I recieve four emails concentrating on the same comment. Will there be in any manner you possibly can remove me from that service? Thanks!

http://thehot.me/how-to-be-beautiful/

Theola Kadow

Theola Kadow

An example of this is Atypical Mole Syndrome. This syndrome brings about a tendency inside the physique to kind an abnormal amount of moles on our skin. This is some thing that we could have obtained from our parents or our grandparents and we’ve no manage over regardless of whether we obtain it or not.

http://thehot.me/the-hidden-secrets-of-makeup/

Duncan Claybron

Duncan Claybron

You decided not to get into extreme detail, however you presented the requirements I want to to get me thru. If you are hoping to get started with a project this really is the facts that is needed. Having more writers join the dialogue is usually a great thing.

http://thehot.me/how-to-be-beautiful/