Log Shipping using Redgate

Hello there,

I am trying to setup Log Shipping between two SQL server 2008 database. They are on different network. One is in the datacenter and one is in our office. I installed the RedGate Backup at the datacenter side. Now the stage where I nee dto give a network path. I have placed a Seagate NAS at my office and created a folder called redgate which i gave read,write access. Now when I enter the static IP of the NAS like so, \\38.45.123.154\redgate i get folder does not exists.
On the datacenter server when i enter this IP in the RUN of windows,it opens the folder window. What am I missing,please help!!

cheers
Zolf
zolfAsked:
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.

arnoldCommented:
sql can not back up to a network directly, you have to add a backup device which will be a url share on both sides.

a better option would be to setup a vpn between the two.
zolfAuthor Commented:
Thanks for your feedbacks. But it is not clear what you meant  
you have to add a backup device which will be a url share on both sides.

As I stated I do have a backup device i.e. Seagate NAS which I trying to use as the Share network for the two server
arnoldCommented:
The device needs to be added on the sql server using SSMS under server objects, backup devices.

....
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

zolfAuthor Commented:
Can you please tell me how or provide some links where it shows me how i can do it
arnoldCommented:
Here is the reference
https://msdn.microsoft.com/en-us/library/ms189109%28v=sql.100%29.aspx

Thedificulty with this setup is that it will write out a single specific file such that should the other side miss an import the DBs will be out of sync.

IMHO, instead of starting with where you are, define what it is you want to achieve and then see whether redgate is the way to achieve what you need/want.

are you trying to have the Dbs online on both ends, or is it a standby type of setup, the DB is in recovering mode onto which it restores transaction logs?

Is DB mirroring an option? (you would need to make a VPN connection between the systems.........
zolfAuthor Commented:
Thanks for your feedback.

What I am trying to do is I have a production server where users do their daily work on it. Now on this server I also have a set of users who only us the database for reporting. Now due to these 2 set of users using the single server which has my SQL server 2008 database on it. the performance of my application has become slow. I want to divide these 2 set of users on different servers. The production server will be used by the first set of users and the users who only use if for reporting I want to setup another server which will contain data from the previous day.So these report server will be one day behind the production server which is fine. I will sync the reporting server every night with the production server.
arnoldCommented:
what versiom of sql standard/enterprise?

log shipping, the db to which log is shipped is not live.

ent version and mirroring/log shipping you could create a snapshot on the other side that the reporting side will query.

as data accumulates over time the needed resources expand.,
zolfAuthor Commented:
Thanks for your comments. I have attached a diagram showing my layout and my goal. Hope it makes things easy for you now to understand what I am tring to do.

1
what versiom of sql standard/enterprise?

It is SQL Server 2008R2  Developer

log shipping, the db to which log is shipped is not live.
Yes it is not live. the reporting server will only be used for reporting.

ent version and mirroring/log shipping you could create a snapshot on the other side that the reporting side will query.

as data accumulates over time the needed resources expand.,

Did not understand what you meant.
zolfAuthor Commented:
Please somebody help!!
arnoldCommented:
I do not believe the redgate log shipping will do what you are looking for meaning a redgate log shipping destination server making the database available to offload your report query away from the production server.
Presumably this is the redgate walkthrough you looked at
http://www.red-gate.com/products/dba/sql-backup/walkthroughs/#log-shipping


An enterprise version of SQL server makes it possible to use the standby mirrored DB (Slave) or a DB o subject to log shipping (restoring state) as the base from which a snapshot can be created and queried offloading the reporting load to the "offline/backup" sql server.

The further difficulty is that it is unclear whether you took the network latency/cost/impact or whether those who need reports or whether you have reporting setup on the remote or the users will have to remote.
zolfAuthor Commented:
Thanks for your comments. Yes that is correct I was following that link to create the log shipping. I am stuck on stage 3 as I mentioned in my beginning of my post.
arnoldCommented:
Do you have an option to establish a VPN between the two servers?

A NAS can not be ..........
zolfAuthor Commented:
yes I have the option...but what use will vpn be of
arnoldCommented:
you would be able to transfer the transaction logs directly between the two systems.  usually the log shipping is made up of three tasks
1; generate the log
2: notify the destination
3: destination: copy the log
4: restore the log
5: on the source: maintain space by deleting transaction logs older than 72 hours or ....
6) destination: cleanup the copied transaction logs

or
DB mirroring might become a possibility
You are trying to use the NAS as an intermedierry.
and this will only get you to a point of having the DBs in sync with one being in recovery mode, getting you back on how you would access the data there.

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
zolfAuthor Commented:
thanks
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
Storage Software

From novice to tech pro — start learning today.