i need a script to stop SQL services so the sims backup (scheduled nt backup) can start, then a reboot / shutdown (in a set amount of time / when the back ups done) so the services will start again.
Anyone got a script like this? if not what do you use to backup sims and stop SQL??
Thanks in advance :D
Stop SQL services
if SQL Services are stopped
if backup complete / if time >= 10 mins
start sql services
if script does not work
Place gun to head
Echo Starting to Backup the SIMS Database
C:\Program Files\Microsoft SQL Server\MSSQL$SIMS\Binn\dbattach
/backup /auto /server=<servername\instance name> /database=SIMS
Echo Finished Backing up the SIMS Database
AT 22:00 /Interactive /Every:M,T,W,Th,F C:\Backup\SIMSBackUp.Bat
Why not do a maintenance task in sql manager to create a backup of the Sims / other databases and move them to another location? It can also clean up the database and a few other options.