Tuesday, March 20, 2012

backing up 2005 to something I can restore to 2000

I have an exiting database which I'd rather not manually recreate that I'd
like get a backup file from that I can restore to a 2000 database.
Is this in principle possible?
PaulYou cannot restore a SQL Server 2005 backup to SQL Server 2000. You have to
transfer objects instead using SSIS.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"PJ6" <noone@.nowhere.net> wrote in message
news:eGgw0I%23iGHA.4284@.TK2MSFTNGP05.phx.gbl...
> I have an exiting database which I'd rather not manually recreate that I'd
> like get a backup file from that I can restore to a 2000 database.
> Is this in principle possible?
> Paul
>

No comments:

Post a Comment