I am working in a software firm as a DBA from last 6 months.Till now i a have done some simple tasks like migating database ,creating table, writing SP's etc.
Now i have alloted a tough job to configure sql server cluster.About that i dont know anything.
these are my requirements :
we are having 2 servers.we need to install sql server on both system with the same name and with the same databse structure. one is having records of upto 2005 year and other with 2005 above records.through the application we have to switch on to different database.Is it possible.
Kindly show me the right way.
name: swapnil udasi
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!