Log shipping SQL 2008 from SQL 2008?

Question

Post reply

Log shipping SQL 2008 from SQL 2008?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
December 11, 2011 at 9:36 pm

#248008

Hi,
Can we possible for configure log shipping between SQL 2000 and SQL 2008?
Primary server
windows server 2003 enterprise edition.'
SQL server 2000 enterprise edition. SP4
Database size - 450 GB
Secondary server
windows server 2008 enterprise edition R2 - 64 bit
SQL server 2008 enterprise edition. SP3 - 64 bit
Thanks
ananda

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

MasterDB Hall of Fame Points: 3054 More actions · Answer 1

No, Not possible..

DR Server should be same version and same edition.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

this question has been raised before, yes it is possible but there are caveats around it

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

It’s right time for planning a database upgrade 😉

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 4

Dev (12/12/2011)
It’s right time for planning a database upgrade 😉

Hi Dev,

It is right for upgrade sql server 2000 to SQL server 2008.

I am not getting more downtime for upgrade sql 2000 to 2008 and 750 GB database size. so in this case planning for upgrade sql server 2008 through log shipping.

could anyone advise and give me step by step document for implement log shipping sql 2000 to sql 2008.

regards

ananda

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 5

ananda.murugesan (12/16/2011)
Dev (12/12/2011)
It’s right time for planning a database upgrade 😉
Hi Dev,
It is right for upgrade sql server 2000 to SQL server 2008.
I am not getting more downtime for upgrade sql 2000 to 2008 and 750 GB database size. so in this case planning for upgrade sql server 2008 through log shipping.
could anyone advise and give me step by step document for implement log shipping sql 2000 to sql 2008.
regards
ananda

Just wanted to know why do you want to use Log Shipping for the upgrade? You can just backup the primary Server and restore it to the secondary with no recovery, then just restore any differential and transaction log backups you may have taken on the primary. I don't think you need to setup log shipping.

My blog

baabhu SSCertifiable Points: 6205 More actions · Answer 6

Hi Ignacio A. Salom Rangel,

Very curious to knew about this, is it possible to take database backup from sqlserver 2000 and restore on sql 2008.

-- Babu

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 7

Sure! You can always make a full backup of a SQL2000 Server and restore it on a SQL 2008 Server. I'm not sure how would that work with the diferential backups! But I will test it and let you know.

My blog

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 8

I just tested and it works! You restore the full backup with norecovery and the you restore the differential. The conversion to 2008 only occurs after the last restore. I hope this helps. Good luck. 🙂

My blog