Restoring a SharePoint Site database grows too big for my Hard drive

Posted on 2011-10-31
Last Modified: 2012-05-12

I am trying to restore my sharepoint site using the instructions at

When I begin the second command to restore the site, the database (which is created in C:\Program files\Microsoft Sql Server\MSSQL$SHAREPOINT) Grows bigger than the available space on the C Drive.

I was wondering how to restore the site, with the database situation on one of the other hard drives which has lots of free space.

Thanks in advance
Question by:e2e01
    LVL 38

    Accepted Solution

    You could detatch the content db from SQL, move it to the new location, then reattach.

    1. Stop all SharePoint services on your SP servers (including the web http service) though services.msc.

    2. In SQL management studio, detach the content database

    3. In windows Explorer, move the mdf and ldf files to the new hard drive

    4. In SQL management studio, attach the database from the new location

    5. Start all sharepoint services

    6. restore the site

    Author Comment

    Can you elaborate on how to find the database in the management studio?
    LVL 38

    Expert Comment

    If you dont know the name of the content db, go into Central Admin - Application Management - Content Databases.  Select your web app and it will show you the db name(s).

    Author Comment

    I've managed to move the database... thanks A lot! :) Let's hope it works! :D

    Author Closing Comment


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    731 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

    15 Experts available now in Live!

    Get 1:1 Help Now