Link to home
Start Free TrialLog in
Avatar of QPR
QPRFlag for New Zealand

asked on

Attach existing DB as new content DB

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?
ASKER CERTIFIED SOLUTION
Avatar of Mohit Nair
Mohit Nair
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of QPR

ASKER

That worked... once I remembered to give the correct NTFS permissions on the new path!
Thanks.