Solved

SQL Server & Server 2003 restart w/ .bat

Posted on 2010-08-19
2
441 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Order by but want it in specific order 2 26
ms sql + top 1 for each customer 3 43
Intel Server Board SE7525GP2 Doesn't Recognize Full Hard Drive Capacity 4 84
Sql query 107 27
Learn about cloud computing and its benefits for small business owners.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now