GK GK
asked on
Logshipping between two Datacenters- SQL Server 2008(Std) to SQL Server 2012(Std)
Hi All,
I need help from experts with scripts and new ideas to Implement logshipping between two Datacenters- SQL Server 2008(Std) to SQL Server 2012(Std).
Some body help us with scripts or steps to implement successful logshipping configuration.
Regards,
GK
I need help from experts with scripts and new ideas to Implement logshipping between two Datacenters- SQL Server 2008(Std) to SQL Server 2012(Std).
Some body help us with scripts or steps to implement successful logshipping configuration.
Regards,
GK
ASKER
Hi Deepak,
I need to configure logshipping between instances which are in Different Data centers ,That means there is no communication between the Instances and only way I can move backup files with Server Message Block (SMB) folders.That means I con't go with regular lagshipping configuration available in SQL Server.
Hence I'm looking for Manual script to configure logshipping Technic with scripts.
Hope you understood requirement,Please let me know if more information requires.
Regards,
I need to configure logshipping between instances which are in Different Data centers ,That means there is no communication between the Instances and only way I can move backup files with Server Message Block (SMB) folders.That means I con't go with regular lagshipping configuration available in SQL Server.
Hence I'm looking for Manual script to configure logshipping Technic with scripts.
Hope you understood requirement,Please let me know if more information requires.
Regards,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How to migrated SQL Server with minimal down time when Server are in Different domains ,Different data centers and not possible to create users to access the folders.
https://msdn.microsoft.com/en-us/library/ms190640(v=sql.100).aspx
But remember this will always one way, (SQL 2008 to SQL 2012) you can not reverse it.
Suppose your primary server (sql 2008) fail in this condition you can online secondary server but you can not setup logshipping again between these these instances because of version difference.
If your requirement something like database upgrade or migration that's fine. But for HA this is not a solution. You should go with Replication.