Ederwainer
asked on
Configure Task Scheduller under windows 2003 server to reestart SQL Server Express every morning
Hello,
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.
Thanks!
Eder
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.
Thanks!
Eder
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.