Log Shipping & DataBase Mirroring

Question

Log Shipping & DataBase Mirroring

OnlyOneRJ

Hall of Fame

Points: 3894
More actions
August 27, 2012 at 6:19 am

#261000

I am New to the Log Shipping & DataBase Mirroring, unfortunately i am asked to perform this by Client 🙁
an any one help me as to how should i do this..
I mean All steps, What to do, What not to do etc :crying:
In my system i have SQL SERVER Enterprise Edition 2008
I have two different systems having servers in it which are Standard Edition 🙁
Please guide me, as how how how should i do it .....
thanks 🙂
************************************
Every Dog has a Tail !!!!! :-D

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Start with the pages in Books Online on Database Mirroring and Log shipping. There's lots of info there. If you've done that, try google, there are lots of blog posts and white papers.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 2

Hi Gila,

Thanks for the quick reply, i do have some stuff's and links..

I am not sure whether the link is complete solution....

http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/

1) Can you tell me whether the above link is complete & i should start working according to it.. will that help me complete in LOG SHIPPING??

2) Also the links only provide step to step procedure of LOG Shipping..but i never got an info of what should i be ready with before moving to LOG Shipping 🙁

3) As i am asked to perform the LS task, what all help should i take from other departments?? like Network dept, Admin dept etc... as they give us the access to what we have requested... but i dont know what to request 🙁

************************************
Every Dog has a Tail !!!!! :-D

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

I think you need to do a lot more research. Start with Book Online, after that look for the HA/DR whitepapers from Microsoft. Alternately, suggest to your client that they hire someone with HA/DR experience to design and implement the solution.

HA/DR is not an area that you want to make mistakes in, mistakes cost money, they cost jobs.

Edit: You also absolutely have to design it according to the client's RPO and RTO and then implement a test setup and see how well it works.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Divine Flame SSCoach Points: 15943 More actions · Answer 4

runal_jagtap (8/27/2012)
I am New to the Log Shipping & DataBase Mirroring, unfortunately i am asked to perform this by Client 🙁
an any one help me as to how should i do this..
I mean All steps, What to do, What not to do etc :crying:
In my system i have SQL SERVER Enterprise Edition 2008
I have two different systems having servers in it which are Standard Edition 🙁
Please guide me, as how how how should i do it .....
thanks 🙂

First of all, don't be disappointed or sad. Its an opportunity for you to learn if you are going to make your career as SQL DBA :-). Regarding the steps, if you just google "SQL Server database mirroring step by step" you will get many good articles which are providing screen shots for the configuration.

Here is one of the excellent articles on mirroring setup by Brady:

http://www.sqlservercentral.com/articles/Database+Mirroring/72774/

you can find similar good article regarding the log shipping if you search them on google.

If you face any problem when you are configuring mirroring or log shipping, post the error here & we should be able to help you.

P.S.: After reading the above discussion I feel the same way that you need to learn a lot before you setup a DR. It seems that you were not working as a DBA & have been forced into this situation (a new accidental DBA:-D!). You can follow the step-by-step articles for learning purpose however.

Sujeet Singh

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 5

Thanks Gila & Divine 🙂

Will try out the steps but what should i be ready with apart from the steps???

I have got system with Enterprise edition & two servers to practice on..

just want to know what all rights should i ask to perform LOG Shippings?

************************************
Every Dog has a Tail !!!!! :-D

Divine Flame SSCoach Points: 15943 More actions · Answer 6

runal_jagtap (8/27/2012)
Thanks Gila & Divine 🙂
Will try out the steps but what should i be ready with apart from the steps???
I have got system with Enterprise edition & two servers to practice on..
just want to know what all rights should i ask to perform LOG Shippings?

Below are the URLs where you can read about prerequisites:

For Mirroring:

http://msdn.microsoft.com/en-us/library/ms366349(v=sql.90).aspx

For Log Shipping:

http://msdn.microsoft.com/en-us/library/ms190640.aspx#Prerequisites

Sujeet Singh

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 7

I am going to take what Gail said up a notch: it is utterly ridiculous for this client to ask you to set up their HA/DR stuff given that you have no experience/training doing it!! There is no WAY an untrained person can a) figure out what the client REALLY needs and b) get it properly set up and c) properly test it with regards to a new HA/DR implementation. This client is not just setting you up to fail, they are setting themselves up to LOSE THEIR COMPANY when things go south!! And yes, there are entities that WENT OUT OF BUSINESS because they didn't have good HA/DR (and some of them THOUGHT they did, but it wasn't done properly).

PLEASE try to get your client to engage a qualified individual to at least assist you in planning/implementing/testing this requirement!!

My $0.02, based on almost 2 decades of doing SQL Server work.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

TheSQLGuru (8/28/2012)
PLEASE try to get your client to engage a qualified individual to at least assist you in planning/implementing/testing this requirement!!
My $0.02, based on almost 2 decades of doing SQL Server work.

+1

Out of interest, Is your client aware you don't have the necessary skills or are they under the impression that you do?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 9

I cannot question the client directly as to what he is up to.. its just that i am asked to learn and implement LS on Test servers & if it runs correct then the same setup needs to be done in accordance to Production..

Whatever i am going to do will be only on Test server as of now..

************************************
Every Dog has a Tail !!!!! :-D

MissTippsInOz Hall of Fame Points: 3160 More actions · Answer 10

runal_jagtap (8/28/2012)
I cannot question the client directly as to what he is up to.. its just that i am asked to learn and implement LS on Test servers & if it runs correct then the same setup needs to be done in accordance to Production..
Whatever i am going to do will be only on Test server as of now..

Sounds, then, like your client is well aware that you have no knowledge or experience in this area, but they are happy to provide you with the time and resources to get up to speed. That being the case, you can tell the sys admins and network guys to back off while you research and spend time building a test environment in your lab. Once you've had the opportunity to configure one or both you will probably have more specific questions that this forum can help you with.

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 11

MissTippsInOz (8/29/2012)
runal_jagtap (8/28/2012)
I cannot question the client directly as to what he is up to.. its just that i am asked to learn and implement LS on Test servers & if it runs correct then the same setup needs to be done in accordance to Production..
Whatever i am going to do will be only on Test server as of now..
Sounds, then, like your client is well aware that you have no knowledge or experience in this area, but they are happy to provide you with the time and resources to get up to speed. That being the case, you can tell the sys admins and network guys to back off while you research and spend time building a test environment in your lab. Once you've had the opportunity to configure one or both you will probably have more specific questions that this forum can help you with.

Thanks Clare 😎

************************************
Every Dog has a Tail !!!!! :-D

Perry Whittle SSC Guru Points: 234013 More actions · Answer 12

runal_jagtap (8/28/2012)
if it runs correct then the same setup needs to be done in accordance to Production...

😀

Log Shipping is not a new feature, it's solid and robust and it does exactly what it says on the tin 😉

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 13

Perry Whittle (8/29/2012)
runal_jagtap (8/28/2012)
if it runs correct then the same setup needs to be done in accordance to Production...
😀
Log Shipping is not a new feature, it's solid and robust and it does exactly what it says on the tin 😉

Perry, I mean to say that only :-D:-P

************************************
Every Dog has a Tail !!!!! :-D