Need to backup 2005/2008 and restore to SQL2000

GaryC

Hi,

We have a live server which is currently SQL 2000 but we need to use better hardware, so we are going 64-bit. This means a move to SQL 2005 or 2008, but...

...on a monthly schedule we copy databases from live to a data processing server where we update these, and then put them back to live. Using native SQL Backup we cannot get the database from live SQL 2005/8 and put it on our SQL 2000 data processing server. We would prefer not to upgrade the data processing server as it is processing for other live servers which will stay SQL 2000 for now.

Is it possible using Red Gate SQL Backup to take a backup file from SQL 2005/8 and restore to SQL 2000?

I have tried taking a backup from 2005 in Red Gate sql backup and then using command line to restore to 2000 but it did not work.

I have also tried converting the .sqb 2005 backup file to .bak and recovering this to SQL 2000 but this also did not work.

Is it possible?????

Cheers,

Gary.

Nigel Morse

Hi Gary,
I'm afraid I don't think that's possible - SQL server doesn't support it (i.e. you can't go from a later version to an earlier one).

GaryC

Hi,

I wondered if since Red Gate created its own backups they might be in a different format maybe, and than then they might be fully interchangeable?

Cheers,

Gary.

petey

...since Red Gate created its own backups...

That's not what is done. See this article for details on what is actually happening.