[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

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

Hi,

I am trying to restore my sharepoint site using the instructions at http://technet.microsoft.com/en-us/library/cc747463(WS.10).aspx.

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
0
e2e01
Asked:
e2e01
  • 3
  • 2
1 Solution
 
Justin SmithSr. System EngineerCommented:
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
0
 
e2e01Author Commented:
Can you elaborate on how to find the database in the management studio?
0
 
Justin SmithSr. System EngineerCommented:
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).
0
 
e2e01Author Commented:
I've managed to move the database... thanks A lot! :) Let's hope it works! :D
0
 
e2e01Author Commented:
THANK YOU! :D
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now