Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Log Shipping & DataBase Mirroring Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 6:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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

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 !!!!!
Post #1350342
Posted Monday, August 27, 2012 6:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:00 PM
Points: 42,436, Visits: 35,490
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 2008, MVP
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

Post #1350350
Posted Monday, August 27, 2012 6:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 !!!!!
Post #1350354
Posted Monday, August 27, 2012 6:45 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:00 PM
Points: 42,436, Visits: 35,490
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 2008, MVP
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

Post #1350356
Posted Monday, August 27, 2012 6:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 1,306, Visits: 2,470
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

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!). You can follow the step-by-step articles for learning purpose however.



Sujeet Singh
Post #1350357
Posted Monday, August 27, 2012 6:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 !!!!!
Post #1350360
Posted Monday, August 27, 2012 7:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 1,306, Visits: 2,470
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
Post #1350374
Posted Tuesday, August 28, 2012 7:34 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:36 AM
Points: 4,319, Visits: 6,112
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 at GMail
Post #1350923
Posted Tuesday, August 28, 2012 3:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
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"
Post #1351302
Posted Tuesday, August 28, 2012 11:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 !!!!!
Post #1351387
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse