?
Solved

SQL Server & Server 2003 restart w/ .bat

Posted on 2010-08-19
2
Medium Priority
?
448 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
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…
Suggested Courses

771 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