Maintenance Plans vs T-SQL Scripts
by Brent Ozar
Some DBAs prefer SQL Server maintenance plans for database backups and maintenance, while others use T-SQL scripts. Brent explains why in this nine-minute video.
Brent discusses the T-SQL Script Library section here in the wiki where you can get sample T-SQL scripts for index maintenance, backups, developer functions and more.
If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:
- MP4 (Apple) Video Feed
- WMV (Microsoft) Video Feed
- MP3 Audio-Only Feed
- Zune One-Click Subscribe for Video
- Zune One-Click Subscribe for MP3
You can also download this video to watch it later: