| Author |
Restore a backup from SQL 2005 to SQL 2000
|
|
|
| Is it possible to restore a backup from SQL 2005 to a SQL 2000 server?
| |
| Tracy McKibben 2006-11-14, 7:14 pm |
| 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
| |
| Hari Prasad 2006-11-15, 12:12 am |
| 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@sdlgweg90d
flg.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?
>
>
|
|
|
|