Solved

Attach existing DB as new content DB

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

837 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