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.

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

You can also use net stop commands.

http://technet.microsoft.com/en-us/library/ms190236.aspx

http://msdn.microsoft.com/en-us/library/ms187008.aspx

Greg

ASKER CERTIFIED SOLUTION

naomelixes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

coolfiger

Agreed above as well net stop net start in a batch file will work also

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?