You didn’t get this from me. You downloaded it off the internet.
In fact, why don’t I turn that bunch of scripts into a series of jobs and give it to you as one big lump? (Download.)
How to use:
- Load file into SQL Server Management Studio.
- Replace all instances of BACKUP DATABASE [DBNAME] with the proper database name in the square brackets.
- Either create the directory f:\sql or edit the jobs that refer to it to go to a different path.
- Click execute.
And remember, I know nothing. If I knew something, I’d have to charge.
