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
GK GKAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
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.
GK GKAuthor Commented:
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,
GK GKAuthor Commented:
Hi All,
Thanks for Support and comments.
Below step helped me to resolve the issue
Steps
1.Configured Telnet between the servers(Bi-Rectional)
2.Configured the logshipping using Wizard
3.Since two servers are in Different domains and data centres,SQLServer Agent service account  con't access the folders in Primary server
4.Since Secondary server SQLServer Agent service account con't access the folder in Primary server,Job con't copy the backup file to secondary server
5.So,I created additinal step in Copy job(1st Step)  " Net use \\<PrimaryServerIP>\<sharefolderin Primary server> /USER:DomainName\username password"

Note: USER:DomainName\username account created in Primary server(Network share)

So now 1st step in copy job will open the folder in Primary server and copy job step will copy to Secondary server.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GK GKAuthor Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.