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.
i need to enter a command line stop and then start for the services for 2008 sql express. there are 3 sql services running.
Last Comment
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
http://technet.microsoft.com/en-us/library/ms190236.aspx
http://msdn.microsoft.com/en-us/library/ms187008.aspx
Greg
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Agreed above as well net stop net start in a batch file will work also
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.
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.
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?
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?
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://www.petri.co.il/forums/showthread.php?t=15308