如何重命名SharePoint的ContentDatabase

转自http://www.sharepointnerd.com/blog/Lists/Posts/Post.aspx?ID=24

已经过我的验证，切实好用。

用户Attach Database的代码：http://msdn.microsoft.com/en-us/library/ms190209.aspx

1. In Central Administration, take the content database offline.
2. In Central Administration, remove the content database from SharePoint.  You'll get a warning here that any sites in that content database will no longer be available in SharePoint.  While that is true, it does not mean that you're deleting sites; the sites and all their data will remain in the content database.
3. In SQL Server, detach the database.  During this process, it may be necessary for you to also drop all existing connections to the database.
4. In SQL Server, re-attach the same database.  During this process, you should see an "Attach as" column in the upper table; it's here that you can change the name of the database, so call it what you want.  Perform the re-attachment.
5. In Central Administration, add a content database.
   1. Be sure you have the correct web application selected.
   2. Give the "new" database the same name as the one you specified in SQL Server in step 4 above.  (You're not really "creating" a database at  this point because you want to use the existing one that you just re-attached).
   3. Click the "OK" button.
6. The database should now appear as an available database in Central Administration.  If it's not "Started," be sure to start it.  You should then be able to navigate to any site collection contained in the content database.

通过 Wiz 发布