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
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/
0
0
I was studying some of your posts on this website and I believe this web site is rattling instructive! Continue putting up.
https://www.reddit.com/user/ChauSchnur
0
0
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
0
0
Gucci Outlet Will be blogengine far better than wp for whatever reason? Ought to be which happens to be starting to be popluar of late.
http://www.kiwibox.com/bernardinah/mypage/
0
0
The best and clear News and why it means a lot.
http://www.scoop.it/t/click-link-14
0
0
Truly the following information is definitely impressive it really helped me along with my children, appreciate it!
http://www.scoop.it/t/click-link-17
0
0
very nice post, i surely adore this site, carry on it
https://www.interspire.com/forum/member.php?u=425822
0
0
I like your writing style truly enjoying this web site .
http://www.herbaltricks.com/Articles/how-skin-care-serum-can-ease-your-pain
0
0
You made some first rate points there. I appeared on the web for the difficulty and located most individuals will go along with together with your website.
https://www.reddit.com/user/OdiliaWontorq
0
0
“Many people got trouble with their loans, hope you don’t get the same problem”
http://www.huntingnet.com/forum/members/gussiebabia.html
0
0
I precisely desired to thank you so much all over again. I do not know the things that I might have tried in the absence of those basics documented by you
http://www.kiwibox.com/jadwigapenc/mypage/
0
0
I enjoy reading article. Hope i can find more articles like this one. Thanks for posting.
http://www.fontspace.com/profile/bernardinah
0
0
There is clearly a lot to know about this. I think you made various good points in features also.
http://www.scoop.it/t/click-link-8
0
0
Sometimes your blog is loading slowly, better find a better host..-,~”
http://www.herbaltricks.com/Articles/how-skin-care-serum-can-ease-your-pain
0
0
There is noticeably big money to understand about this. I suppose you’ve made specific nice points in features also.
https://ilburchoep.wordpress.com/2016/10/14/the-hidden-agenda-of-under-eye-wrinkle-treatment/
0
0
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
0
0
Your blog has the same post as another author but i like your better.~’~:’
http://www.purevolume.com/listeners/liaassaniol/posts/5198530/The+Hidden+Agenda+Of+Looking+Younger+Than+Your+Age
0
0
too much vitamin-a can also cause osteoporosis but aging is the number cause of it`
http://www.herbaltricks.com/Articles/7-reasons-tourists-love-best-anti-aging-eye-cream
0
0
Good publish, adding that to my personal blog right now, thanks.
https://justpaste.it/zezg
0
0
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/
0
0
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
0
0
so much wonderful information on here, : D.
http://articles.org/jacquettapanq/
0
0
maintaining a healthy weight can be tricky because it revolves around genetics and some other factors;
http://articles.org/edwardcentre/
0
0
away many folks who may have been lovers of your website.
http://www.herbaltricks.com/Articles/7-quick-tips-regarding-makeup-samples
0
0
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
0
0
i really like to color my hair and i would love to try different hair colors specially auburn”
http://articles.org/gussiebabia/
0
0
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
0
0
I totally understand everything you have stated. Actually, I browsed through your various other articles and I do think that you’re certainly correct. Best wishes with this particular site.
http://www.herbaltricks.com/Articles/15-things-you-should-do-free-beauty-samples
0
0
pretty practical stuff, overall I feel this is well worth a bookmark, thanks
http://www.herbaltricks.com/Articles/latest-trend-under-eye-wrinkle-treatment
0
0
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
0
0
I got what you mean , saved to fav, very nice website .
http://www.scoop.it/t/click-link-14
0
0
“Xanax (Alprazolam) is used to treat anxiety disorders and panic attacks. Alprazolam is in a class of “
http://www.kiwibox.com/larisarundst/mypage/
0
0
A very informationrmative post and lots of really honest and forthright comments made! This certainly got me thinking a lot about this issue so cheers a lot for dropping!
http://b.hatena.ne.jp/entry/beautynewsnetwork.com/free-makeup-samples/
0
0
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/
0
0
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/
0
0
Hi! Great post! Please do tell us when I will see a follow up!
http://thehot.me/how-to-be-beautiful/
0
0
disaster movie is hilarious, i laugh for hours just watching that movie;;
http://thehot.me/transforming-your-skin/
0
0
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/
0
0
That was a great blog. You made some exceptional points and I appreciate for your insight!
http://thehot.me/how-to-be-beautiful/
0
0
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/
0
0
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/
0
0
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/
0
0
thank-you for this post (désolé, je suis francais, je parle mal anglais)
http://thehot.me/the-hidden-secrets-of-makeup/
0
0
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/
0
0
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/
0
0
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/
0
0
Venus Raj really looks very pretty on the pictures, she is very photogenic”
http://thehot.me/beauty-is-everywhere/
0
0
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/
0
0
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/
0
0
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/
0
0
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/
0
0
The way you write, you are really a professional blogger.’”,`’
http://thehot.me/beauty-is-everywhere/
0
0