backing up 2005 to something I can restore to 2000

microsoft.public.sqlserver.programming

9 Jun 2006 4:31 PM

PJ6

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

9 Jun 2006 4:45 PM

Narayana Vyas Kondreddi

You 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/

Show quote

"PJ6" <no***@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
>
>