none
如何让wss3.0使用wss2.0的数据库? RRS feed

  • 问题

  • 新部署了wss3.0,原来使用的wss2.0的数据库有100G(sql2000)。我想wss3.0能够直接使用wss2.0的数据库。

    我将数据库复制到新的服务器,然后直接附加到sql2005上,然后在wss3.0的管理中心里“添加内容数据库”然后有错误提示:

    尚未在此数据库 SPContentDatabase Name=sharepointdata Parent=SPDatabaseServiceInstance 上运行预升级扫描工具。只有先运行升级前扫描工具,然后才能继续升级过程。请从以下路径运行该工具: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\prescan.exe。

    这个prescan.exe要对数据库sharepointdata做怎样的操作才能顺利使用啊。

    2012年5月9日 2:12

答案

  • Hi bian.s,

    prescan.exe 主要有两个目的。

    1.解析和保存相关列表的定义。

     2.prescan.exe可以报告一般的问题,并将升级过程中的错误issue报告出来。

    以下是tecnet 上对prescan.exe的英文理解。

    Understanding PRESCAN.EXE in MOSS 2007

    Prior to upgrading to Microsoft Office SharePoint Server 2007/Windows SharePoint Services 3.0 one of the prerequisites some of you may have already noticed is running PRESCAN.EXE from the installation directory.  This post will hopefully provide some insight into PRESCAN.EXE as well as best practices on when it should be run.

    PRESCAN.EXE has two primary purposes:

    It parses and saves List definitions with the associated Lists.  SharePoint Portal Server 2003 Service Pack 2 already incorporates this feature whenever a list is modified; however, this process should be completed for all Lists, so prescan calls the SharePoint Portal Server 2003 Service Pack 2 method to persist that data.

    PRESCAN.EXE will report on common issues that will result in a failed upgrade; therefore, running PRESCAN.EXE, addressing reported issues, and resolving those issues, and re-running PRESCAN.EXE to verify those fixes is a best practice when planning a Microsoft Office SharePoint Server 2007/Windows SharePoint Services 3.0 upgrade.  The most commonly detected issues are:

    Database Orphans This is a class of issue where an object exists, but the pointer with the parent object is broken and/or corrupt.   Classic examples include situations where a site exists in the content database; however, does not exist in the configuration database and a web that points to a site collection that no longer exists. 

    Missing Site Definitions This issue is rare at best ad exists when a site collection has been removed/deleted - sites under this classification will not be upgraded and in addition those sites will not render in SharePoint Portal Server 2003/Windows SharePoint Services 2.0.

    Typically these issues will manifest as a result of failed STSADM backup and restore sequences, but also can occur at the SQL level.

    Depending on the nature and growth of your environment, PRESCAN.EXE is best run one (1) week prior to the production upgrade allowing time to address issues uncovered, and again prior to the upgrade itself to ensure that those previous issues have been resolved in addition to identifying new issues, if any.

    你可以参考如下链接。

    http://blogs.technet.com/b/wbaer/archive/2006/05/09/understanding-prescan-exe-in-moss-2007.aspx

    更多关于PRESCAN.EXE ,请参考如下英文连接。

    http://support.microsoft.com/kb/937291/zh-cn

    Thanks,

    Jack



    2012年5月10日 8:24
    版主