PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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

58 Comments on “What should you do?

  1. Reta Poaipuni says:

    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
  2. Carlo Quihuiz says:

    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
  3. Thomasina Randklev says:

    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
  4. Lauren Tocci says:

    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
  5. Kenyetta Becvar says:

    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
  6. Ricky Krnach says:

    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
  7. Ward Estep says:

    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

Leave a Reply