i have 2 computer and both has SQL SERVER 2008 R2 , one of them is running on Windows SERVER 2008 R2 and the other one is Windows 7 Pro ..
My goal is mirroring database for Fail-over between -Windows Server 2008 R2 computer should have principal databse and Windows 7 pro should have mirror and withness database...
Also optimize the database , it is pretty large around 20 gig..
I ll provide logmein access to both computer ..they are running in the same location and WORKGROUP , NOT DOMAIN !
SQL Mirroring is something I work on everyday. I'll most likely solve most of your problem in one line of code and will check your Server configurations for other issues.
13 freelancers are bidding on average $98 for this job
Hi, I can make mirroring between database. It is necessary to make all those server in same network. Please see PM.
Dear Sir, I have over 5 years of experience in databases Sql Server, Oracle, Microsoft Access and MySQL, Programming Languages (VBA, .Net technologies(Asp.Net, Vb.Net / C#.net ) , C, C++ and Vb 6 Scripting Daha Fazla
Hi, I am working as DB Administrator for 4+ years. Your problem can be solved easily. Please check my message!
Hi, We can do mirroring and reduce db size. really it is big database, it takes time to optimize, but we assure you to do it in real time.
Need Expert, May I Help You? You can see my profile. Thanks.
I'll not write here about my [url removed, login to view] you got actual idea about my work when I accomplished this work.
I am working in the computer Company for five years in the data maintenance field. I can do it for you.
I am an expert in the MSBI tools and will be able to do this wokr with great accuracy and quality