Solved

Attach existing DB as new content DB

Posted on 2015-01-06
2
89 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 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 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