.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Async Mirroring

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :SharePoint
Does SP 2010 Support Async Mirroring? Also, what do I lose, if I do mirroring outside of SP. (So SharePoint is not aware that SQL is being mirrored).

View Complete Post

More Related Resource Links

question on async data mirroring


In Async (high perf) data mirroring, if the primary goes down and it has some items which were committed on primary but were not relayed to the secondary. (may be there were in the send queue).

What happens to those?

Will I have to force the mirror server to come up (thereby loosing the data in the queue?).

In this scenario, is there a less destructive way where I don't end up loosing the data which was committed on the primary (apart from switching to high-safety).

Easy Async: Build Concurrent Apps From Simple F# Expressions


In this article, the author explores how the F# language helps you create asynchronous function libraries that can be called seamlessly from any other .NET-compliant language.

Chance Coble

MSDN Magazine October 2008

Advanced Basics: Doing Async the Easy Way


If you've been following Ted Pattison's excellent series of Basic Instincts columns on multithreading and asynchronous behavior, you should by now be an expert on handling the issues involved in working with multiple threads in Windows®-based apps.

Ken Getz

MSDN Magazine March 2005

TDE key rotation in the database mirroring situation.

I have set up database mirroring for TDE enabled database and they worked fine as far as I got all the key infrastructure identical on both Principal and mirrored SQL servers. Now it is coming to our yearly key rotation practice for compliance.  After I regenerate the DEK on principal server and also encrypt it with a newer certificate,  the mirroring is suspended and I am not able to resume it any more.  (Although I have added this newer certificate to the mirrored server too.) It is understandable because now the DEK is out of sync.  However, what are the correct steps to do the key rotation in the mirroring scenario? The bottom line is:  I DO NOT want to set up mirroring again since our backups are huge and take very long time to copy the backups from principal server to mirrored server. thanks for any input in advance.  

SQL Server Mirroring

If when using SQL Mirroring does it replicate both ways I.e Server A and Server with Serve A as principal server, Server A falls over for whatever reason and B then becomes used server. When A comes back online will Server B replicate all changes to A and will B become the Principal server.

Best way for Async File Upload

Hi experts,I need to upload files asynchronously, in a user friendly manner.Do asp.net provide any such control/toolkit?What is your suggestion for async file upload for my new website? Should I use any 3rd party control?Thanks for your reply in advance.

Async Web Service behavior on client disconnect

Hi all, I was wondering what is the best way to detect client disconnect in the middle of an async web service call. I'm asusming that if a client disconnects while the server is still processing the async web method call, an exception will be thrown. First, I wonder if someone can confirm that this is the right assumption. If that's the case, then I was wondering where should I set up the SEH block to catch this exception. My gut tells me to set up the SEH block in side the delegate funciton, but I might be wrong. Also, what kind of an exception would I be getting if the client disconnects? Finally, if the SEH is set up in the delegate, what happens if a client disconnects in the tiny window before or after the delegate gets called? If someone can shed some light here I'd really appreciate it! Thanks, - K.  

Async Tasks: Simplify Asynchronous Programming with Tasks

Asynchronous programming lets you run expensive operations concurrently without blocking the UI thread. We'll show you three simple techniques for implementing asynchronous operations in your code.Igor OstrovskyMSDN Magazine September 2010

Async Agents: Actor-Based Programming with the Asynchronous Agents Library

The agent model provides an effective method of hiding latency for efficient parallel execution. The Asynchronous Agents Library (AAL) lets you use this actor-based model with message-passing interfaces, and we'll show you how it works.Mike Chu, Krishnan VaradarajanMSDN Magazine September 2010

How to capture the full file path from Async File Uploader Control?

Hi,I have an Async File Uploader control inside a Repeater which is inside an update panel.Now,I am uploading the file into ftp,so I am not uploading the video file,using SaveAs() method.For uploading the file in ftp,I have this UploadFile method which takes these four parameter:FileName, UploadPath, FTPUser, FTPPassword.Now this FileName,I have to send the full file path. My UploadComplete event looks like this:<pre lang="cs">protected void AsyncVideoUpload_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)      {//VideoPath is a session variable            VideoPath = string.Empty;            if (AsyncVideoUpload.HasFile)            {               // string filepath = AsyncVideoUpload.PostedFile.FileName;                  string filepath = e.filename;//above two captures only the file name,but I want the total path,like c:/MyDocuments/...                                 UploadFile(filepath, "","test","Value*12"); &

mirroring with SQL Alerts or Sharepoint Failover?¿

Hi, I´ve installed a Sharepoint Server 2010 (RTM) Farm and configured database mirroring in SQL server 2008(both in Windows Server 2008 R2) by alerts that give control to the mirrored instance changing the alias in all Sharepoint Servers. It works fine, but I´ve just noticed that Sharepoint has an utility that makes Failover automatically if I configure it by scripts in Powershell. My question is, ¿which way is better? ¿can I use both? ¿Does Sharepoint Failover work properly when a database fails and how it do it? Thanks in advance

Mirroring fails (Error: 1418)

Our configuration: Two separate boxes running SQL Server 2008 R2.  On box A we have the principal database.  Box B holds both the mirror and the witness.  We are using the Mirroring Wizard.  Both boxes are on the same domain. We followed the following steps to try and establish the mirror: Backed up the database from  box A Backed up the transaction log from box A Restored the backup on box B using the RESTORE WITH NORECOVERY option Restored the transaction log on box B using the RESTORE WITH NORECOVERY option Run the mirrorring wizard on box A At this point I get an error message saying that the mirror database on box B cannot be reached (Error: 1481).  The mirror database on box B is in the "Recovering" state because we used the RESTORE WITH NORECOVERY option.  It's interesting to note that if we restore the database on box B using RESTORE WITH RECOVERY, we then get the same error message but this time it says that the principal database on box A cannot be reached. What gives?JC

After async postback, hide/show panel stops working

I have a Gridview in an UpdatePanel with a column containing an "expander" button that shows (and hides) more detail beneath its row of data.  It all works great until the user pages the gridview.  After the async postback to page the gridview, the javascript function to toggle hide/show appears to work flawlessly (the expander's button image even changes correctly), but the detail panel just doesn't show on the page.Note that my expander control supports a "AsyncTriggerId" property that, if set in the markup, will rebind the javascript toggle function when that control triggers an async postback (see OnPreRender below)Here's the hide/show toggle javascript:function toggleExpander(divId, imgId) { var div = document.getElementById(divId); var img = document.getElementById(imgId); var cssClass = div.getAttribute("className"); if (div.style.display == "" || div.style.display == "none" || cssClass == "hidden") { div.style.display = "inline"; div.setAttribute("className", ""); img.src = "images/dir_down.png"; mce_src = "images/dir_down.png"; img.alt = "Collapse to hide details"; } else { div.style.display = "none"; img.src = "images/dir_rig

Modal Loading Popup on Async Postback

Hi everyone, I have a web application that does some complicated data retrieval tasks and so I am trying to show a modal dialog box with a loading message when the tasks begins. I am using ASP.Net 3.5, the jQeury popup I am using is bPopup. Firstly, I have a table where the rows can be clicked. Im am using a script from http://bloggingabout.net/blogs/mveken/archive/2008/01/02/performing-async-postback-from-javascript.aspx to do an async postback from the table row. Here is my functionfunction Server(eventName, eventArgs) { $("#<%=lDiv.ClientID %>").openPopup(); var prm = Sys.WebForms.PageRequestManager.getInstance(); if (!Array.contains(prm._asyncPostBackControlIDs, eventName)) { prm._asyncPostBackControlIDs.push(eventName); } if (!Array.contains(prm._asyncPostBackControlClientIDs, eventName)) { prm._asyncPostBackControlClientIDs.push(eventName); } __doPostBack(eventName, eventArgs); } so the $("#<%=lDiv.ClientID %>").openPopup();  opens up my loading modal and then the server starts doing its thing. When the server finishes though how would I then close the dialog box? I just need to call one line of code like $("#<%=lDiv.ClientID %>").closePopup(); Thanks for your help

If one database goes down in database mirroring then other will come up but because there is no Virt

In database Mirroring can I have a virtual IP... Please tell fast.. Actually we were trying to install the sql server cluster but thats not possible bcoz it is in production of Domino Server.My confusion is "If one database goes down in database mirroring then other will come up but because there is no Virtual IP type of thing in this then how my application will connect to another without manual interruption of IP change..."     "SQLSERVER DBA" "INDIA"

Mirroring SharePoint Conent DB

Hello Everyone, If SQL Mirroring is being configured on SP 2010, is there a limit on the number of content databases which can exist on one node? SQL Mirroring Infrastructure itself would consume resources in terms of un-compressing the log and the rolling forward the DB.

SQL Server 2008 Database Restore(Database Mirroring)

HI,I tried to impliment Database mirrorin in SQL Server 2008.I have 3 Sqlserver 2008 Eneterprise Edition in 3 diiferent computers with same domain.Pricnicipal server =TCP://SPHDev.sphinet.com.sg:5022.Mirror=TCP://SPHPrimary.sphinet.com.sg:5022 and witness =TCP://wsc211.sphinet.com.sg:5022.But when i click start mirroring button i got an error TITLE: Database Properties------------------------------ An error occurred while starting mirroring. ------------------------------ADDITIONAL INFORMATION: Alter failed for Database 'SPH_MSCRM'.  (Microsoft.SqlServer.Smo) ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The server network address "TCP://SPHPRIMARY.sphinet.com.sg:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418).This is the error message i got from Error Log"2009-06-03 17:01:08.89 spid27s     Database mirroring connection error 2 'DNS lookup failed with error: '11001(No such host is known.)'.' for 'TCP://SPHPRIMARY.sphinet.com.sg:5022"I restored Principal server DB  by using RESTORE WITH NORECOVERY and now this  database in mirror server is now look like as DBName(Restoring....).How i can identify
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend