?
Solved

Attach existing DB as new content DB

Posted on 2015-01-06
2
Medium Priority
?
94 Views
Last Modified: 2015-01-07
I need to add a new content DB (sharepoint 2013). The difference between this one is that it will be on tier 2 storage so will not use the default SQL Server paths for the mdf and log files.
I I create this new DB in SQL Server can I "introduce" it to SharePoint rather than create it in Central Admin?
I know I can use Mount-SPContentDatabase to use an existing content DB but this will be a empty newly created DB does this make a difference?
I could always create it using central admin and then dettach it, move the files to the desired location and then attach it again.
Which is best?
0
Comment
Question by:QPR
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
Mohit Nair earned 2000 total points
ID: 40535016
I would suggest you to create using central admin, then detach and attach by moving the files. Let SharePoint create it on default path and then you can move it.
0
 
LVL 29

Author Closing Comment

by:QPR
ID: 40536956
That worked... once I remembered to give the correct NTFS permissions on the new path!
Thanks.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

765 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