Business challenge:
SQL Server Express is a free edition and is available with a number of restrictions. Some examples are. Size should not exceed 10GB.SQL Server Agent is disabled. Auto tasks are disabled. One of the common problem we face is disk space on these databases. To ensure up time and proper functioning of database we should enable backup of database. And these backups needs to be automated. Since we don’t have the Server Agent and task scheduler the process is not straight forward.
UFT comes into show:
Use of windows task scheduler along with SQL script to back up the database. Create an SQL script that will back up the database and then purge the contents of the database.
Impact Delivered:
Created a scheduled task in task scheduler to run the created SQL script and stores it in a specified path on the system. Create a notification action about the scheduled task in the scheduler. If the task fails, investigate the event log and re-run the task manually. Delete older backups from the system after a certain period.