Solved

Attach existing DB as new content DB

Posted on 2015-01-06
2
85 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
2 Comments
 
LVL 9

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

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…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 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