Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server & Server 2003 restart w/ .bat

Posted on 2010-08-19
2
Medium Priority
?
449 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
Norush earned 2000 total points
ID: 33477841
0
 

Author Closing Comment

by:myreallife
ID: 33477884
Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

618 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