You may have not have performed an in-place upgrade correctly? Does the server now have two instances of SQL Server running? have a look in services.
You can use the Database Copy Wizard to migrate your 2005 db's if you now have a 2005 and 2008 SQL running.
You may also try attaching the 2005 mdf files from Management Studio in 2008, right click on user databases and select attach. This should allow you to attach the 2005 db's and upgrade them to 2008.
发布评论
评论(1)
您可能没有正确执行就地升级?
服务器现在是否有两个正在运行的 SQL Server 实例? 看看服务。
您可以使用数据库复制向导来迁移 2005 数据库,如果您现在正在运行 2005 和 2008 SQL。
您还可以尝试从 2008 年的 Management Studio 附加 2005 年的 mdf 文件,右键单击用户数据库并选择“附加”。 这应该允许您附加 2005 数据库并将它们升级到 2008。
You may have not have performed an in-place upgrade correctly?
Does the server now have two instances of SQL Server running? have a look in services.
You can use the Database Copy Wizard to migrate your 2005 db's if you now have a 2005 and 2008 SQL running.
You may also try attaching the 2005 mdf files from Management Studio in 2008, right click on user databases and select attach. This should allow you to attach the 2005 db's and upgrade them to 2008.