Avatar of russgarrett
russgarrett
 asked on

sql express 2008 stop start

i have a single workstation running Acronis backup software to a local usb drive and to off site backup to Acronis.

i need to enter a command line stop and then start for the services for 2008 sql express. there are 3 sql services running.
Microsoft SQL Server 2008Acronis

Avatar of undefined
Last Comment
russgarrett

8/22/2022 - Mon
coolfiger

try the sc command. you can write a batch file that stops the service and can be run by task scheduler

http://www.petri.co.il/forums/showthread.php?t=15308

JestersGrind

ASKER CERTIFIED SOLUTION
naomelixes

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
coolfiger

Agreed above as well net stop net start in a batch file will work also
Your help has saved me hundreds of hours of internet surfing.
fblack61
russgarrett

ASKER
i want to stop the SQL services to make sure they do not keep the databases open and prevent the Acronis software from backing up the databases.

this was also recomended by the application software company.

i am not a SQL guy so i am just following their directions and convering my butt.

i also thought the services should be stopped because there is a reason Backup Exec sells a SQL add on for their back software.

i hope to have access to the machine today.
russgarrett

ASKER
So if i enter in the Acronis software  c:\net stop SQL Server Agent (instancename) and then after the backup c:\net start "SQL Server Agent (instancename)" this will solve the issue?

if there are more than on instance running i should create a batch file file called for example "sql stop" and "sql start"  and enter the command an instance per line. then enter this in Acronis.

i can also verify that the services stop by checking them during the backup and after in the SQL 2008 manager.

correct?