Saturday, February 25, 2012

Restore a backup from SQL 2005 to SQL 2000

Is it possible to restore a backup from SQL 2005 to a SQL 2000 server?
Zack wrote:
> Is it possible to restore a backup from SQL 2005 to a SQL 2000 server?
>
Nope. This has been asked here about six times in the past 2 weeks,
search around and you'll find some alternative suggestions.
Backup/restore is not possible.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Hi,
Due to architectual differences you can not restore a database backup from
higher version to Lower version [SQL 2005 to SQL 2000] . But it is always
possible to restore the
SQL Server 2000 backup to SQL Server 2005 server. Only solution is to create
the database manually, create objects and use SSIS/DTS/BCP to transfer the
data.
Thanks
Hari
"Zack" <svoiasgfs@.sdlgweg90dflg.com> wrote in message
news:eTRxDDCCHHA.4672@.TK2MSFTNGP02.phx.gbl...
> Is it possible to restore a backup from SQL 2005 to a SQL 2000 server?
>

No comments:

Post a Comment