.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

Terminate Restoration after last transction.

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server
Forgot to select "With Recovery" while restoring last transction file - now how do i get the db out of Restoring mode.
________ Regards, Sachin Ranka

View Complete Post

More Related Resource Links

terminate session

is there a way to terminate user session after leaving my website.. =)

COM+ Instability causing processing terminate on Win 2003 SP2

Hi All,
I'm pulling my hair out with this one. I have a .NET 2.0 application where some of the components are hosted in COM+ (Enterprise Services) and in some cases, calling the
components can cause COM+ to fail.
The following is logged in the event log:

Event Type:    Error
Event Source:    COM+
Event Category:    (98)
Event ID:    4689
Date:        10/08/2007
Time:        11:53:20
User:        N/A
Computer:    LGXSERVER1
The run-time environment has detected an inconsistency in its internal state. This indicates a potential instability in the process that could be caused by the custom components running in the COM+ application, the components they make use of, or other factors. CTransactionMarshal::MarshalInterface

Server Application ID: {C2F97EAF-47B3-446E-BB54-C5E76F5918CC}
Server Application Instance ID:
Server Application Name: lgxEWorkflowEvents
The serious nature of this error has caused the process to terminate.
Error Code = 0x80030009 : Invalid pointer error.
COM+ Services Internals Information:
File: d:\nt\com\complus\src\comsvcs\txprop\txmar.cpp, Line: 198
Comsvcs.dll file version: ENU 2001.12.4720.3959 shp

This is on a Windows 2003 server running service pack 2.
I get no such problems on a Windo

Kill/terminate/stop the main application




I have a winforms application.

From the main application i am starting another app using the following code:


System.Diagnostics.Process.Start(Application.StartupPath &

"\Update.exe", arg)


When this app starts, i want to kill the main app. Close the open application.

how can i do it?

There is aprocess.kill but it is not taking any  arguments. How can i kill the main app from the second app?



point in time restoration



 I have question on this backup\recovery.Let's assume there is a disaster at 6:14 pm and our recovery model is full and we take Full back up's at 12:00 am and differential's at 6 hrs interval and transactional one's for every 5 mins. So, in this case to recover the db, we apply our FB(12:00)+Differential(6:00pm) + Transacational log 1(6:05)+transactional log(6:10) . We need to backup the tail to get the point in time restoration. Could any one tell when shall we  backup the tail log?

is it before doing the restoration??


Restoration of web application using database backup



I have the database backup of one webapplication.

i have restored it and create a new webapplication using the restored database. now, i dont know how to access the site collections. Please guide me. Thanks in advance.

How to update workflow task and terminate workflow using silverlight client object model.



I have created a sequential workflow using visual studio. I also created a content type inherited from the workflow-task content type. Workflow creates a task-item in the task list. I want to update the workflow task using the silverlight client object model. I find on the internet and WorkflowTask.AlterTask() method to update the workflow task item. But I didn't find the equivalent of WorkflowTask.AlterTask(). Can any one help me to update the workflow task from the silverlight client object model?

I also want to terminate the workflow instance using silverlight client object model, but i didn't find any way to terminate the workflow using client object model?

terminate workflow through sharepoint designer



Same question as mentioned in following thread.. but Environment is SP 2010.


1. Is it possible to cancel or terminate workflow through SPD 2010?

2. Is it possible to execute custom code in SPD 2010?

[[[I already checked the 3rd party one which supports Custom code execution. (http://sharepointblog.virtosoftware.com/blogs/virtoteam/archive/2010/03/11/how-to-terminate-all-faulting-sharepoint-workflows.aspx) Please dont propose this solution.]]]

Is there any other solution (free one)?


SharePoint Designer 2007- Terminate a workflow automatically.



How to terminate or cancel a running workflow automatically through SharePoint Designer???

I know that there is a action known as "Terminate workflow" to stop the workflow manually.

Whenever an item is changed, automaticaly start this workflow". Whenever an item is in "In Progress" state, waiting for event date and then sends the mail ( pause state ).
Any help greatly appricated...
Srikanth Reddy.

Close all form and terminate app in .net CF



I've been searching for a while for a solution to accomplish above subject, I have a win app for handhelds in which the user can navigate through several windows forms form.showdialog() The question is how to close all windows and terminate the app when user press exit button.

process.getcurrentprocess().kill(); --> didn't work
Foreach (Form frm in Application.OpenForms) --> doesn't work in .net Compact Framework

I mean if I use form.show() to open the windows, it works with Application.Exit();, but I want to prevent the user navigate away from the current form thru the icon for open windows on the right lower corner of the handheld, unless he press the close button of the form, that's why I use form.showdialog(), the other approach could be to show only the current open form of the application if the user press the icon for the open windows on the right lower corner.

Ideas welcome, thx

Timeout or terminate WaitForConnection in a server NamedPipe - .Net 3.5


.Net 3.5 My communication between the application server and various clients (on other machines)  via Named Pipes is generally okay, but what if the client (the small app that is listening on the named pipe) is not up and running? The application on the server has many responsibilities and having it wait forever to send info via the pipe to a particular client is not acceptible.


pipeIO = new NamedPipeServerStream(pipeName, PipeDirection.InOut); pipeIO.WaitForConnection();

SQL Server Permissions, restoration after computer crash



A week ago my system's hard drive suffered a rather tedious hard drive failure, which I was able to resolve but has created some other issues after the fact.  The Hard drive developed a fault, and in order to restore my system, I was forced to use BartPE as a live cd, and transfer the data from the "defective" drive to the new drive.  for some reason the defect caused a fault which prevented most Imaging software from being able to image the drive over so I was forced to use XCOPY.

Yes, this actually worked, and as I am writing this post, it is my exact same system that I used last week, with the minor problem of having to reactivate windows when I finally was finished.

However, there apparently is a minor issue with the NTFS security descriptors.  I am not surprised, since I was using the BartPE loaded windows system to transfer the files I expected a little "renaming" of security descriptors to occur in the process.  But when faced with the prospect of rebuilding the entire system from scratch, this was a reasonable cost.  However, this tragically confused Sql Server. 

As we know SQL Server Installs Several Groups into the User And Groups of the system:

  • SQLServer2005SQLBrowserUser$COMPUTERNAME
  • SQLServerMSSQLServerAD
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