Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL-Server-Service-Delay

Author  Topic 

FrankSausH
Starting Member

10 Posts

Posted - 2010-05-13 : 06:45:03
Hello,

How can i start the ms-sql-server-service with a delay of 60sec.?

Regards


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-13 : 12:21:43
Create a batch file to pause for 60 seconds, and then run NET START.

Why do you want to do this though?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

FrankSausH
Starting Member

10 Posts

Posted - 2010-05-13 : 12:51:36
Hi Tara,
what content has the batchfile? And then? Set the service to manual? NET START shows the started services. When do i start the batch? Ah in the Autostart, right? But what content?
I only want to relieve my system.

Regards
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-13 : 13:06:26
Relieve your system from what? What symptoms are you experiencing?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

FrankSausH
Starting Member

10 Posts

Posted - 2010-05-13 : 13:26:54
SQL-Server (and other services) should start with delay, so that booting is faster...
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-13 : 13:40:49
I disagree completely as getting SQL back online as fast as possible is critical, but here's a link that shows ways to pause a batch file:
http://www.robvanderwoude.com/wait.php

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -