New SharePoint Video Tutorial: Moving a SharePoint Content Databa se To A Different Disk on the Same System

Moving a SharePoint Content Database To A Different Disk on the Same System - view details

When you install Windows SharePoint Services 3.0 on to Windows 2003 server, by default it will install a SQL Server Embedded edition to host to the database. The database, by default, will be built on the C:/ drive. In this video we're going to take a look at how you can you the SQL Server Express tools to move the database to a different drive letter, because perhaps you're running out of room on the C:/ drive or your database design is needing you to move the database. This is a fairly quick and easy thing to do, provided you have the right tools.

Highlights from this video:

• Downloading/opening the SSMS tools
  
• Connecting to your SQL Server
• Where is all of my SharePoint content located?
  
• Information about the content databases
  
• Detatching databases from the server
• Suggestions for pre-detatchment
• Why did my "Detatch Database" fail?
• Adding databases to a new disk drive

and much more

---

• Source: http://www.learnsharepoint.com
• Category: SharePoint Administration: Common Tasks and Tools
• Skill Level: 300 (Intermediate)
• Length: 12:45 (13.5MB)
• Applies to Versions: SharePoint 2007
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: move, moving, database, sql, ssms, management studio, disk, drive,