SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


LOG SHIPPING by two different systemt architecture?


LOG SHIPPING by two different systemt architecture?

Author
Message
SQL Galaxy
SQL Galaxy
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2546 Visits: 3465
Hi,

Can we able to configure for LOG SHIPPING by two different systemt architecture?

source server
-------------
System type – windows 2008 R2 enterprise edition 64 bit operating system
Database – MS SQL SERVER 2008 Enterprise edition 64 bit

Destination server
--------------------
System type – windows 2008 enterprise edition 32 bit operating system
Database – MS SQL SERVER 2008 Enterprise edition 32 bit

Thanks
ananda
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10164 Visits: 6378
Yes if the destination is of the same SQL version or higher.

Log shipping doesnt matter if its 32 bit or 64 bit.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


SQL Galaxy
SQL Galaxy
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2546 Visits: 3465
I have doubt, destination server - SQL 2008 32 bit enterprise edition, it is not higher then source server.

source server - SQL 2008 R2 64 bit enterprise edition.
Pl. confirm.

thanks
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10164 Visits: 6378
ananda.murugesan (1/8/2013)
Hi,

Can we able to configure for LOG SHIPPING by two different systemt architecture?

source server
-------------
System type – windows 2008 R2 enterprise edition 64 bit operating system
Database – MS SQL SERVER 2008 Enterprise edition 64 bit

Destination server
--------------------
System type – windows 2008 enterprise edition 32 bit operating system
Database – MS SQL SERVER 2008 Enterprise edition 32 bit

Thanks
ananda


Your original post says that both SQL servers are SQL 2008 Enterprise, 1 is 64 bit 1 is 32bit.

You detail that the operating system is 2008R2 on one and 2008 on the other.

So what is it, are the SQL Servers different versions or is it just the OS, or is it both?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


SQL Galaxy
SQL Galaxy
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2546 Visits: 3465
ok, Thanks...the same version can possible to configure for log shipping...not concern with 32 or 64 bits and 2008 R2
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10164 Visits: 6378
Logshipping is basically doing backup and restore, so the same backup and restore rules apply, you can do it to the same version or a higher version.

But once you have restored to a higher version and made it active, you cannot logship back as you will be going from higer version to lower version which cannot be done.

So best in a logshipping environment to have the same edition and level of SQL on both source and destination.

Logshipping and backup restore doesn't care if the server is 32 bit or 64 bit.

SQL 2008 to SQL 2008, logshipping will work ok, can fail back
SQL 2008 R2 to SQL 2008 R2, logshipping will work ok, can fail back
SQL 2008 to SQL 2008 R2, logshipping will work ok, CANNOT fail back
SQL 2008 R2 to SQL 2008, logshipping will NOT work,



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


renaud.quintin
renaud.quintin
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 30
Hello,

Do you know if log shipping is functionning in this case :

SQL server 2008 R2 --> SQL server 2012 SP1 ?
In StandBy Mode

Because when i configure log shipping on my 2008 R2, i have this message for the first Full backup restore :

"System.Data.SqlClient.SqlError: This Backup cannot be restore with WITH STANDBY because it's need an update car la mise à niveau d'une base de données est nécessaire. Réexécutez RESTORE sans WITH STANDBY. (Microsoft.SqlServer.Smo)"


Any idear ?
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10164 Visits: 6378
Yes, 2008 R2 to 2012 will work, but it can only be used for 1 way, once you make the 2012 instance active (WITH RECOVERY) you will no longer be able to logship back to 2008 R2 (role switching will not be allowed back to make 2008R2 primary).

You cannot put a database into STANDBY mode when crossing version, it has to be in NORECOVERY mode.

If you need the secondary copy to be in STANDBY then primary server will need to be 2012 or secondary server will need to be 2008 R2



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


renaud.quintin
renaud.quintin
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 30
Thanks for your reponse.

So i need upgrade my Primary to 2012 for my readOnly Database on my secondary server.
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10164 Visits: 6378
Yes, or downgrade your secondary to 2008 R2.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search