是否可以将MS SQL 2005备份还原到MS SQL 2008实例上? [英] Can an MS SQL 2005 backup be restored onto an instance of MS SQL 2008?

问题描述

是否可以将SQL Server 2005数据库的备份还原到SQL Server 2008实例上?

Is it possible to restore a backup of a SQL Server 2005 database onto an instance of SQL Server 2008?

由于服务器越来越笨拙，我需要重建它，因此我打算借此机会升级到SQL 2008，并想知道我是否能够恢复我的备份.

I need to rebuild a server as it's getting rather crufty, so I plan to take this opportunity to upgrade to SQL 2008 and wondered if I'll be able to restore my backups OK.

推荐答案

从2005年升级到2008年是可以的，向后移动可能需要更多工作

Upgrading from 2005 to 2008 is OK, moving back might require more work

您的数据库登录名可能有问题(因为新服务器主数据库中将不存在登录名)，但是无论服务器版本如何，都会发生这种情况.只需重新创建它们并与您的数据库重新关联即可.

N.B. You might have a problem with your database the logins (as they will not exist in the new server master db) but that's something which would happen regardless of the server version. Just re-create them and re-associate with your database.

这篇关于是否可以将MS SQL 2005备份还原到MS SQL 2008实例上?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！