Link to home
Start Free TrialLog in
Avatar of GK GK
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
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

Here is both using script and UI method.

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.
Avatar of GK GK
GK 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,
ASKER CERTIFIED SOLUTION
Avatar of GK GK
GK GK

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GK GK

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.