How to Move SharePoint Databases?
-
2011년 1월 24일 월요일 오후 12:53
I've installed SharePoint locally which has created a SharePoint SQL Server instance locally and has about 15 databases + 5 content databases.
I'd need to use our shared DB server so I'd have to move all the databases to this new DB server instance and make my central administration to point to that server instead.
How could I achieve this?
Many thanks.
모든 응답
-
2011년 1월 24일 월요일 오후 12:57
This is the article for you: http://technet.microsoft.com/en-us/library/cc512725.aspx
I'd recommend you look deep in the SQL Alias part, they offer you many benefits like moving and upgrading DB's.
SharePoint 2010 MCM. Feel free to contact me http://www.sharepoint.bg/radi -
2011년 1월 24일 월요일 오후 1:11
Thanks Radi.
is it possible to change the name of the databases which are used by sharepoint? e.g. Bdc_Service_DB_d8f1b9484e904c42a1ee90cb37b8b235 to MyInstance_Bdc_Service_DB_d8f1b9484e904c42a1ee90cb37b8b235.
-
2011년 1월 24일 월요일 오후 1:34
Hi, Todd Klindt wrote something about that (http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?List=56f96349%2D3bb6%2D4087%2D94f4%2D7f95ff4ca81f&ID=221&Web=48e6fdd1%2D17db%2D4543%2Db2f9%2D6fc7185484fc). For what I know you can do that on some of your dbs but not to all.
Cheers
Riccardo-update-
I found another useful post by Shane Young http://msmvps.com/blogs/shane/archive/2010/10/26/getting-rid-of-guids-in-sharepoint-2010-database-names.aspx
fino a quì tutto bene- 답변으로 표시됨 Lily Wu 2011년 2월 6일 일요일 오후 2:21
-
2011년 1월 24일 월요일 오후 2:26
Renaming is not something I would feel safe about, although it is "possible. This is the article from MS on it: http://technet.microsoft.com/en-us/library/ff851878.aspx
The crap DB names are created by the Farm Configuration Wizard. Avoid using that. Provision your service applications with PowerShell, where you can create proper DB names.
There's a lot of examples on the web, like http://sharepoint.microsoft.com/blogs/zach/Lists/Posts/Post.aspx?ID=50
and definitely check out http://sppowershell.com/ from fellow MCT Shannon Bray.
SharePoint 2010 MCM. Feel free to contact me http://www.sharepoint.bg/radi- 답변으로 표시됨 Lily Wu 2011년 2월 6일 일요일 오후 2:21
.png)
