Solved

SQL Server & Server 2003 restart w/ .bat

Posted on 2010-08-19
2
443 Views
Last Modified: 2012-05-10
I am running Microsoft SQL Server 2005 on Server 2003. I use a .bat file to restart Terminal Servers (shutdown.exe /f /r /m \\XXXXX) on a schedule but to do this on SQL server I need it to shutdown gracefully. So the perfect situation would be for the SQL Server Agent to shutdown first, then SQL Server itself and last the 2003 Server would restart. I can’t find a .bat script to handle this... Any thoughts?
0
Comment
Question by:myreallife
2 Comments
 
LVL 7

Accepted Solution

by:
Norush earned 500 total points
ID: 33477841
0
 

Author Closing Comment

by:myreallife
ID: 33477884
Thanks
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Analysis of table use 7 49
How to place a condition in a filter criteria in t-sql (#2)? 10 50
Please help for the below sql query. 1 25
convert null in sql server 12 34
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question