Scripts Thread, SIMS Script in Coding and Web Development; i need a script to stop SQL services so the sims backup (scheduled nt backup) can start, then a reboot ...
2nd March 2011, 09:23 AM #1
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
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
2nd March 2011, 09:39 AM #2
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
2nd March 2011, 10:19 AM #3
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.
By McTedo in forum Scripts
Last Post: 21st March 2014, 12:16 PM
By vikpaw in forum MIS Systems
Last Post: 25th October 2011, 09:38 AM
By aneena in forum MIS Systems
Last Post: 22nd May 2010, 01:19 PM
By academic_mwnci in forum MIS Systems
Last Post: 3rd September 2008, 12:02 AM
By nicholab in forum MIS Systems
Last Post: 27th April 2007, 08:17 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)