.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

Replication: Server restart vs service restart

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

Replication does not break when i restart the SS Agent, however, when there is a server restart, i get a message : The process was successfully stopped. and the Subscription Status is NOT RUNNING? Why does this happen? Does Tx replication not automatically sync after a server restart?

View Complete Post

More Related Resource Links

Restarting Server: How to restart User Profile Sync Service?


Greetings all,


We had to restart our server, and once restarted, the User Profile Service (that we so laboriously fixed/reconfigured a month back) isn't starting. We get a retry on "User Profile Sync is provisioning, please wait..." before it terminates.

Can someone please recommend the best order in which to re-start the services so User Profile Sync restarts and continues to update?

Thanks SO MUCH,


Restart the server that has been configured for subscriber in a transactional replication


Whats the impact on restarting the server that has been configured for subscriber in a transactional replication.

The distributor and the publisher have been set on different servers.

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Doesn't restart sql server rollback uncommitted transaction?

hi, i executed a long-running sql in the management studio. The sql updates many rows and all updates are within a transaction. After runing 30 mins, the hard disk is full. That's because of the uncommitted updates. Then, i restarted the sql server because I thought after restarting, the uncommitted transaction is rollback and the occupied hard disk space is also released. But i found that the transaction is rollbacked but the hard disk space is not released. Why the hard disk space is not released? how can i release the disk space now? Thank you for your help.

Setup of SQL Server 2008: Restart required but I have restarted

Hello,I have tried to install SQL Server 2008. I cannot install, because I get the errormessage the prerequistite "Restart the computer is required".But every time I restart my computer and try to execute the setup of SQL Server 2008, I get the same message, I have to restart the computer.I cannot install the SQL Server 2008. What can I do?Thanks

WCF Service hosted in IIS 6 failing on idle timeout and does not restart

I've got a WCF service hosted in IIS 6 with its own application pool.  The application pool is running under a domain service account.  It appears that the application pool's idle shutdown setting is killing WCF service and subsequent requests to the WCF service get an exception as listed below I can only access after I browse to the .svc page in order to get it working again.   I've went through the svc tracing and able to see where the ServiceHost closes down. I have tried various session management techniques with no result. I haven't read anything about having to disable the idle timeout in IIS 6 when hosting a WCF service, and I suspect that there shouldn't be any need to.   Can anyone provide any insight into why this is happening?   ******************* My client exception ******************* Test method **********  threw exception:  System.ServiceModel.ProtocolException: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '<html>     <head>         <title>Runtime Error</title>      

Hw can i restart the central administration service?


Hi ,

Accidentally i stop central administration service (operations->services on server).

How can Central Administration Service be restarted? Cannot go to Central Admin, when the service is not running :-)

Please help me out




Log Reader Agent fails to restart when server restarts


when our server reboots and by way of that, SQL Server restarts, the Log Reader Agent fails to restart despite appearing to be set to do so (restart when SQL Server Agent starts).  SQL Server Agent does restart, but the LRA needs manual intervention.



How to start or restart share point server 2010



Good evenning all,

i want to ask you that how to start or restart share point server 2010 that is already installed

on my machine. Explain step by step.

I need to start it.


Problem with Reporting Services -- Report Hangs sometimes, need to restart server



We are having an application in which we generate several kinds of reports. We have one report- person addresses, through which we generate the report for all the people whom we have to deliver the cards. This is one of our most frequently used reports.

Some time back, we started getting problems of reports hanging on blank white page and nothing comes up. We restarted the server and everything wents fine. After some more days, the problem occurs again and again we restarted the server.

From that time the problem is coming up again and again and everytime we needs to restart server to make it work. But we cant do that every time ..Can anyone please suggest what may be causing it?

Database server: sql 2000

reporting services : Microsoft SQL Server Reporting Services Version 8.00.1062.00

operating system on which report is running: Microsoft Windows NT 5.2.3790.0

Application is build in .Net 2003

Sometimes the problem comes in 2 weeks, and sometimes it comes twice in a week.

Restart SQL Server Agent on Distributor

Can we Restart  SQL Server Agent on Distributor during the transactional replication?
Will the replication pick it up once the SQL Servernt agent service is brought up?

Constant 'server restart pending' whenever I try to install Sharepoint Server 2010 Beta


I've installed all the prerequisites just fine, but every time I run the main installation program it tells me:

"Setup is unable to proceed due to the following error(s):

A system restart from a previous installation or update is pending. Restart your computer and run setup to continue."

After restarting, and doing nothing else, I run the setup again to get the same result.  There are no pending restarts, Server Manager itself normally complains if there is a restart pending, so I don't know where it is getting this from.

THe next thing I will try is to give it a little more RAM in case it makes a difference; the virtual machine currently has 4GB overall and has a few other minor roles as well.  But it would make sense for the installation program to say that instead of telling me it's a reboot.


Dev Lunsford

Restart SQL Server from a client using SMO


This is what I am trying to do:

From my client box (Windows 7 32bit) I want to run a program that I am writing that will go to my server box(Windows 2008 R2 64bit) and restart SQL Server(2008 R2).

Here is a snippet of the code I am using:

    using Wmi = Microsoft.SqlServer.Management.Smo.Wmi;

    . . .

    Wmi.ManagedComputer mc = new Wmi.ManagedComputer("MyServer", @"MyDomain\MyUserId", "MyPassword");
    foreach (Wmi.Service srvc in mc.Services)
        Console.WriteLine("  " + srvc.Name);
    Wmi.Service srv = mc.Services[@"MSSQL$SQL2008"];
    startWait = DateTime.Now;
    while (srv.ServiceState != Wmi.ServiceState.Stopped)
        if (DateTime.Now - startWait > new TimeSpan(0, 0, 30))
            throw new Exception("Sql Server Shutdown Timed out");

"Requested Service not found" on client when restart service with a .NET MarshalByRef remoting proxy


I have a client application that uses a single remoting entry point (a MarshalByRef class) to access a range of other MarshalByRef services on the server.

The server:

public class ServiceManager : MarshalByRefObject, IServiceManager
  IService1 service1;
  public ServiceManager(IService1 service1)
    this.service1 = service1;
  public override object InitializeLifetimeService()
    return null; // never expire

  public IService1 GetService1()
    return service1;

public class Service1 : MarshalByRefObject, IService1
  public override object InitializeLifetimeService()
    return null; // never expire


SSRS service intermittently stops, won't restart.



I've been having some issues lately with my SSRS 2008 R2 installation.  Its up and running for a few months now with no major issues but i've encountered a problem over the past few weeks that is very intermittent and hard to troubleshoot. 

The actual reporting services service will stop (inaccessible via report manager) and has to manually be restarted. I've configured service recovery of 'Restart the Service' and even tried to have it run a batch file that restarts it to no avail. 

I've also tried setting it to 'delayed' as i know some services' dependencies can cause stoppage if not running. The report manager is always slow to load on first load of the day and can sometimes cause the service to stop. I've also run random reports and had the service stop w/o warning yet after a restart it can run for days without happening again.

Quick background: Windows Server 2008 x64, MSSS 2008R2 x64, SSRS 2008R2, Xeon Quad w/8gb DDR3, MINIMAL server load at any given time and there are no 'end users' on this yet, just me. 

Event Log from last service failure:

Log Name:      Application

Source:        Application Error

Date:          4/5/2011 2:01:33 PM

Event ID:      1000

Task Category: (100)

Submitting ASPX form does not work until i restart the server


I have a ASPX form that when submitted does an update to a table on MS SQL Server.  This works fine 99% of the time.  Sometimes it times out and I cannot submit that form from that computer until I restart the server.  I can go to other forms and submit which does pretty much the same thing but updates other tables.  When I go back to the trouble form and try again it still times out.  I then remoted to another location to try from there and it worked fine with exactly the same data.  Came back to problem computer/form and still no go.  I tried another browser on the same computer and no go there as well.  I also tried updating another record in the same table and still got the problem.

So it seems that once the problem starts, it seems to lock any updates from just that computer and to that table.  Weird!!!

I have tried recycling the Application Pool, restarting IIS, SQL Server and the Firewall (both server and local) but the only way to fix it is to restart the server.

Your help would be very much appreciated.




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