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

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

Best DR solution

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server

We are having 2 SQL Server 2005 EE databases(on Windows 2003 EE) of different sizes ( 60G and 1.5TB(includes BLOBS)). We are planning for a DR solution for this database.

This is only for DR and not for load balancing purpose, the secondary database would be only used when primary fails or during maintenance of primary database. The amount of redo generated for 1Tb database would be 1G per day and for the other smaller database it would be 500M per day. The network would be able to handle bandwidth upto 1.5Mbps. We dont have a shared location between these two servers for security purposes. We want the DR to be exact copy of the primary and in case of the DR, the secondary would become the primary and the primary database needs to take on the secondary role without much reconfiguration(not looking for a complete restore as this may slow things). DR would be initated manually so wouldn't want that to happen automatically.

I did go through Peer to peer transactional replication and SQL Mirroring but not sure what would be the best fit here?

Any suggestions? I am an Oracle DBA with little knowledge on SQL Server, so any help would be very much appreciated.

Will replication/mirroring be possible between two different version?

View Complete Post

More Related Resource Links

Complete SQL Solution

SQL Server Solutions: SQL Server 2000/2005 Related Free Snippets.

Solution/project structure


Hello, I am working in a aspx web application that must be built in several separate "modules" with different functionality which will be partly developed by different teams.

However, I need the completed app to reside in ONE virtual directory. There will be a single startup page. I need session state to be preserved across pages in different modules.

I structured it as one solution with different Web Projects and one class library project with common functionalities.


1) is this the right approach to do this? Or which one would be better?

2) each time I add a new web project to the solution, a new web.config gets created. What do I do and where do I put them?

VS 2010 + framework 4.0 + TFS

Regarding TFS and source control, I have a single Team project, the solution and web projects are inside it.



Arabic QueryString with Url Rewrite Solution


Alsalamo 3alaykom ,

as we know that if you use Intelligencia.UrlRewriter.RewriterHttpModule or IIS URL Rewriting , we will face problems with arabic urls

as this

http://localhost:1234/Pages/???? ?????? ?????? ??????????

and the Rule is :

<rewrite url="~/Pages/(.+)" to="~/ShowPages.aspx?Page=$1" />

you will recive the QueryString["Page"] Like this

نائب العميد للشؤون الأكاديمية

so it's a big problem , and there is a solution that is :

remove the Rule of that rewriting ,,

<rewrite url="~/Pages/(.+)" to="~/ShowPages.aspx?Page=$1" />

then open your Global.asax file and Application_BeginRequest method exactly

use the following code to handle you request

void Application_BeginRequest(object sender, EventArgs e)
if (HttpContext.Current.Request.Url.ToString().Contains("/Pages/"))
	String[] txt= Regex.Split(HttpContext.Current.Request.Url.ToString(), @"/");
	String page = txt[txt.Length-1];

AD FS 2.0 in Identity Solutions: Using Active Directory Federation Services 2.0 in Identity Solution


This article explains how you can use Active Directory Federation Services (AD FS) 2.0 to claims-enable Windows Communication Foundation (WCF) services and browser-based applications. The focus is on the token issuance functionality in AD FS 2.0. You'll find out how to use AD FS 2.0 as an identity provider; set up an AD FS 2.0 security token service (STS) to interact with WCF; federate AD FS 2.0 with your custom STS or another AD FS 2.0; enable Web single sign-on and federation with WS-Federation and SAML 2.0 protocols; and externalize authentication logic through Visual Studio. You'll come away appreciating how AD FS 2.0 and Windows Identity Foundation make programming identity solutions in Windows less of a chore.

Zulfiqar Ahmed

MSDN Magazine November 2009

BizTalk EDI: Build a Robust EDI Solution with BizTalk Server


We introduce you to the EDI functionality within BizTalk Server 2006 R2, illustrating schema creation, document mapping, EDI delivery and transmission, and exception handling.

Mark Beckner

MSDN Magazine August 2008

Security: Safer Authentication with a One-Time Password Solution


One-time passwords offer solutions to dictionary attacks, phishing, interception, and lots of other security breaches. Here's how it all works.

Dan Griffin

MSDN Magazine May 2008

Office Development: OBA Solution Patterns In The Real World


OBA solution patterns help architects and developers build Office Business Applications (OBAs). This article introduces the seven core OBA solution patterns and applies one to a real-world problem.

Steve Fox

MSDN Magazine March 2008

Office Space: Solution Deployment with SharePoint 2007


WSS 3.0 introduces a new deployment mechanism that lets you move your development efforts into a staging or production environment.

Ted Pattison

MSDN Magazine August 2007

Extreme ASP.NET: A New Solution to an Old State Storage Problem


State management in Web applications is a contentious issue. Should you store user data per session or should you persist it across sessions? You can easily store information temporarily while someone navigates your site by using session state.

Fritz Onion

MSDN Magazine April 2006

Inside MSDN: Using InfoPath as a Reporting Solution


I love the part of my job that lets me write code and develop software. In addition to those responsibilities, however, I manage a development organization that's working on a number of large strategic projects.

Larry W. Jordan Jr.

MSDN Magazine March 2005

Build Solution


 I am following the tutorial http://www.asp.net/mvc/tutorials/mvc-music-store-part-2 and am at the part where I need to build the solution...

When I click the build option at the top I do not get the same menu items...

I get:


Build <Project Name>

Rebuild <Project Name>

Clean <Project Name>

Publish <Product Name>


It doesn't even show the shortcut keys next the the menu items, like Build <Project Name> should show Shift+F6


I have wen't through many options and tried using the shortcut F6 to build solution

Is there something I am missing???



(Imperfect) Solution to TreeView Postback / Client-Side Node Selection Issue


I've seen this question posted on all corners of the web... "How do I disable "AutoPostBack" on the ASP.NET 2.0 TreeView control?!"  Unfortunately, most of the answers either don't work, miss the point (don't work right), or boil down to "You can't do it."  I happen to know that this behavior worked perfectly in the IEWebControls TreeView that Microsoft released as an add-on prior to ASP.NET 2.0, however.  So I set out to find a solution for the ASP.NET 2.0 TreeView issue.

In a nutshell, the behavior that I and others are looking for is to have a TreeView rendered in a page that allows the user to expand, contract, and select nodes within the TreeView without causing a PostBack to the server.  This implies two things: (1) the most recently-selected node should be recorded as the currently-selected node [i.e., at PostBack time, the most-recently selected node is actually represented as the SelectedNode]; and (2) the selected node should exhibit the SelectedNodeStyle as specified in the TreeView declaration.

It appears that the TreeView engineers saw only two possible outcomes from selecting a leaf node in a tree: (1) immediately posting back to the server, or (2) immediately navigating to another web page.  They apparently did not consider option (3) just allowing selection in-place on the client, while waiting for a click on so

Erro While Creating a Solution Package With a timer Job


Hi All,

I am trying to create a test Timer job in SharePoint and want it to be deployed as a solution package. I am using a web application project and added Timerjob.cs, fetaurereceiver.cs, feature.xml and manifest.cml files in in. Then I created a .dff file to arrange the solution package. But when I tried to create a solution package with makecab.exe i got the below error

100.00% flushing current folder

I dont know what to do with that . Please if anyone can send me an example where a timer job was deployed as a solution package it will be of great help




Isha kapoor My SharePoint Blog Follow me

Solution Full Update


I make a project based on WSPBuilder, add there an event handler, compile code, make wsp, deploy.

For the first time i have exact reaction from site as i intended.

Then i retract and delete solution and make several changes to elements.xml. Changing binding of list for exmaple from custom list to tasks:

from <Receivers ListTemplateId="100"> to <Receivers ListTemplateId="107">

Then i go all the way back to solution deployment.

But when i try to fire some events i dont get the effect.

As i`ve found out dll changes are deployed nicely. So if i change cs code i see the effect, but any changes in xmls go nowhere.

Only way no is to make it in a new project.

So how can i update these xmls on portal ?

I see xml are changing corerctly in feature\myevent.

Here is deploy script:

stsadm -o addsolution -filename WSPBuilderProject1.wsp
stsadm -o deploysolution -name WSPBuilderProject1.wsp -allowgacdeployment -immediate
stsadm -o copyappbincontent


Here is retract script:

stsadm -o retractsolution -name WSPBuilderProject1.wsp -local
stsadm -o deletesolution -name WSPBuilderProject1.wsp


What am i doing wrong ?

The language-neutral solution package was not found.


Hope I might be able to find some help on this one...


I developed a simple web part which posts HTML form contents to a SharePoint list - on first deploy, it worked fine, using the Web Part project base from VSeWSS 1.1, but after deployment, I noticed I fat fingered a url for redirection, and went back in to change it. Now, on deployment I get the following error:


------ Build started: Project: ContactUsForm, Configuration: Release Any CPU ------

ContactUsForm -> C:\Visual Studio 2005 Projects\ContactUsForm\ContactUsForm\bin\Release\ContactUsForm.dll

------ Deploy started: Project: ContactUsForm, Configuration: Release Any CPU ------

------ Deactivate and uninstall features in old solution ------

------ Retract and delete old solution contactusform.wsp from the SharePoint ------

Retracting solution ...


Server Error: The language-neutral solution package was not found.

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


I've restarted IIS, recycled app pools, etc., but still keep getting this error and am a bit confused as to where to go next. I followed the steps listed in this blo

Visual Studio 2010 Creates Two Solution Files


When I create a new file system based web application in Visual Studio 2010, for example, named as "MyWebSite", two folders were created by the studio: MyWebSite and MyWebSite(2). The second folder only contains a solution file while the first folder has the solution file as well. Is this a new feature? Where is the setting that can avoid the second folder? Thanks,

Video: Site Collection Solution Galleries in SharePoint 2010

This demonstration shows the solution gallery and solution management features of SharePoint 2010. (Length: 4:01)
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