.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

Recovery questions

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I am about to replace a SQL 2005 database with no high availability options with two SQL 2008R2 boxes. I just have a few questions.

From what I read, database mirroring has automatic failover. So say the client specified TechSQL as the server, how does this name transfer over so the clients still connect when the first mirrored server goes down?

Since I only have two servers at the same physical site, is there a benefit of then adding log shipping, or doing log shipping instead (other than delayed log committal)?

View Complete Post

More Related Resource Links

C# Interview Questions

C# Interview Questions
This is a list of questions I have gathered from other sources and created myself over a period of time from my experience, many of which I felt where incomplete or simply wrong. I have finally taken the time to go through each question and correct them to the best of my ability. However, please feel free to post feedback to challenge, improve, or suggest new questions. I want to thank those of you that have contributed quality questions and corrections thus far.

There are some question in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them easy access

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

Data Recovery Software

Nokia mobile phone bulk SMS sending software sends unlimited text messages through a GSM based mobile phone connected with your computer system to other mobile phone. Bulk message broadcasting application sends business related messages, notifications, personal SMS, share market information, enterprise advertising news etc to any group or individual in a single click.
Group messaging wizard offers latest and advance technology to create and sends bulk text messages/SMS from your computer system or laptop/desktop via GSM based mobile phone to another mobile phone worldwide. Instant SMS sending software easily and smoothly works with all popular GSM mobile phone brands including LG, Nokia, Samsung, Sony Ericsson, Motorola etc. Nokia mobile phone mass SMS sending tool facilitates you to have strong relationship with your family, friends, customers etc.
GSM mobile phone SMS sending program is very useful utility for all small or large business enterprise to increase their business by sending event alerts, notifications, advertising to individual or group of customers. Mass messaging software provides solution to the user to send multiple SMS through GSM mobile phone connected through PC to nationally or internationally network based mobile phones.

Linq qry with order by basic questions


I have never tried a group by with linq, now I do and I'm stuck.

I try to convert this sql statement to its linq counterpart :

SELECT COUNT(tb_Mailer_Smses.Id) AS [cnt], tb_Mailer_mailing.Id As [Id]
,SUM( CASE WHEN tb_Mailer_smses.DLRStatus = 200 THEN 1 ELSE 0 END) As [Delivered]
FROM tb_Mailer_mailing INNER JOIN
tb_Mailer_Smses ON tb_Mailer_mailing.Id = tb_Mailer_Smses.MailingId
WHERE tb_Mailer_mailing.ApplicationId = 1
GROUP BY tb_Mailer_mailing.Id

Is there some one who can me show me the convertion process ?

Questions about getter and setter


I created a getter and Setter in Visual Basic. I have some questions though. Please look at the code below.
Here are my questions.

A.) At line 1 below, should "pieces" be declared as Private?
B.) In the IDE at lines 4 and 7 the IDE keeps changing those variables to uppercase so that the property name "Pieces" is the
    same as the variable name "pieces".Should I instead define the integer pieces with an underscore: _pieces ?
That is the only way I can get around the IDE forcing the variable to become uppercase.


1  Dim pieces As Integer

2  Public Property Pieces() As String
3  Get

4  Return pieces
5  End Get

6 Set (ByVal values As String)
7   pieces=value
8 End Set
9 End Property

SharePoint: Add a Recycle Bin to Windows SharePoint Services for Easy Document Recovery


Windows SharePoint Services helps improve collaboration and workflow while protecting documents and intellectual property. But one feature is conspicuously missing - an easy way to back up and restore deleted files from document libraries. In this article, the authors take advantage of the extensibility of WSS and its server-side and client-side object models to build a restore feature that works like the Recycle Bin in Windows Explorer.

Maxim V. Karpov and Eric Schoonover

MSDN Magazine February 2005

execute update timedout expires , table with trigger due to recovery of database


I have table A in database A  , in table A i have trigger to insert record to database B table A, each update and insert of database A -table A, triiger fire and insert record in database B table A, when i try to update some times asp.net application gives error

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

and then error log says System.Data.SqlClient.SqlException: Database 'database B is being recovered. Waiting until recovery is finished.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean ret

Redirect to Security Questions if Site accessed from unrecognized computer?


I'm fairly new to ASP.NET and i'm using the Membership Provider.  I have the need to do similar to some banking sites. Baically I need to track "authorized" computers/ip's for a user.  If the user accesses the site form a recognized Computer/IP then the user is allowed into the app after successful login.  If the computer/IP is not recognized I need to redirect them to a screen to answer the security question setup in fhte Membership Provider.

Has anyone done anything like this or can anyone point me to any examples?  I did a search, but can't seem to find anything.

My idea is to maintain a list of authorized computers/IP addresses and check them on initial login.  If the IP address isn't found I can redirect them to the questions.  My concern is that they are then actually authenticated and could enter any of the site URL's as an authenticated user.

Any suggestions greatly appreciated. 

This forum is ONLY for accessibility questions about the physically challenged

Nothing more. A mistake was made when changing the description of the forum when adding the 2010 information.
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.

Password recovery by entering email not username



I am using the ASP.Net password recovery control.  By default the user needs to enter their username before an email gets sent out to them.

If it possible instead of entering the username, email is used instead?  Alot of my users forgets their username but not email.


Entities Framework 4 Questions


1. Do you have to setup cascading on the SQL server also, or if you setup Cascading in EF 4 that will do it for you, and you can keep Cascading in SQL not setup?

2. Is there any problems I should be aware of like the problems(yet manual fixble) with  using Cascading in EF 4 , MVC 2, SQL 2005.


Thanks :)



Windows Presentation Foundation (WPF) questions

This forum is for the WPF Designer ("Cider") in Visual Studio. If you have questions about WPF or using the WPF runtime then the WPF forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=119&SiteID=1 is probably a better place to ask your question. mark

web services interview questions.

Hi ,   I am preparing for ASP.NET web service interview.   Can you please send me the FAQ for web services.???   Thanks in advance.   Thanks Narendraan.K

pinvoke / kernel32.dll questions

To date, I have only run my .NET app on X86 boxes.  I would like to run it on Win2008 X64 but am concerned about my use of pinvoke to make kernel32.dll calls. Here are the kernel32.dll calls that I currently use in my app:   [DllImport("kernel32.dll")] static extern void OutputDebugString(string lpOutputString); //used for handling internal exceptions [DllImport("kernel32.dll", CharSet = CharSet.Unicode)] public static extern IntPtr GetModuleHandle(string moduleName); DllImport("kernel32.dll", CharSet = CharSet.Unicode, SetLastError = true)] [PreserveSig] private static extern int GetModuleFileName([In] IntPtr hModule, [Out] StringBuilder lpFilename, [In][MarshalAs(UnmanagedType.U4)] int nSize); [DllImport("kernel32.dll")] private static extern int GetCurrentThreadId(); [DllImport("kernel32.dll")] private static extern int GetCurrentProcessId();   Will these same calls still work on an X64 OS (my App is compiled as AnyCPU)?  Do i need to use different kernel calls when running in 64 bit mode?   thanks      

Database in recovery

Our server ran out of disk space during a stored procedure process. We were able to free up some space, stopped all SQL services, restarted all SQL services and now SQL Management Studio shows the database to be in recovery.  Is there a way to monitor this to ensure progress is being made and to estimate when it might complete?
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