I need guidance on how to setup a task schedulled to run every morning and reset my instance of sql server express.
As you might as why, here is the answer:
I run a dedicated server at godaddy and every night when they run the Netbackup utility from Veritas, if anybody tries to acess a website during the backup process, sql server will disconnect the website's database and I have to reestart sql server express to get them running again.
I already spoke to tech support and they said theres nothing they can do about it and suggested that I create an application to put the websites under maintenance mode during the backup process (every night) or create a schedulled task to reestart the server every morning, after the backup takes place.
I think the second choice is the best and I need guidance for that.