Mar 21, 2010 | Backup, Scripts, SQL Server 2005 |
My last post showed a little script that I use for taking full backups of all my databases on an Instance.This script below will take a transaction log backup of all your database in full recovery mode, again it can be used in conjunction with the SQL agent to...
Mar 18, 2010 | Backup, Scripts, SQL Server 2005 |
We all know the importance of taking regular backups of our SQL Server databases. This is a useful little script that I use to take a full backup of my databases on an instance. It can be used in combination with the SQL Agent to schedule:DECLARE @DBName...
