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.