Need to automate stopping SQL Service before Server backups

[Dylan]

Is thre a simple way to automate stopping the SQL Service prior to scheduled external server full tape backups (using ArcServe). Then after Arcserve is done restart the SQL Service.

Thanks for any help with this ...


TOm Tom Moran
Lansing, Michigan

 

[BeckahC]

Do you need the service stopped? Or would turning it into single-user mode be ok?
BeckahC

 

[Dylan]

I need the service stopped. (all dBs closed)

TOM Tom Moran
Lansing, Michigan

 

[BeckahC]

Sorry, I thought I could help, but I don't know how to automate stopping the services.
I wish I could've been more help. BeckahC

 

[tlbroadbent]

You can use NET STOP mssqlserver from the command prompt to stop the service. Use NET START mssqlserver to start it.

You can also use the SHUTDOWN command in T-SQL.

Setting the databases in Single User mode doesn't solve the problem because ArcServ only backups files that are not in use. If the SQL Service is running, all database files that are attached are in use.

We prefer to do our backups diffrently. We create backups using the Native SQL backup facility. Then we copy the backup files to tape using ArcServ. We don't make the databases unavailable with this technique. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Andles]

Hi Tom

Taking your SQL Server down to do backups is not really appropriate or necessary.

I agree with the response you got indicating they use native SQL backups into a specified directory THEN use ArcServe to pick up these.

Cheers

AJ