Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Venkatesh Krishnamurthy,
This is a simple script to backup your new databases and remove the backup schedule for deleted database in SQL Server 2005/2008.
The backup strategy of my script is given as below:
Creating Backup folder
Update the following variables in the script
@BackupServerNameInput - Enter the Central Backup Server Name
@BackupShareInput - Enter the Share / Local path name.
Note : If you are planning to create backup jobs and start full backup immediately once you implement the job, uncomment the last 2 lines in the script.
Simply execute the SQL script and it will create a Job named as 'Create_Backup_Jobs', once you execute the job it will create backup jobs for every databases.
Script to create datestamp folder causing issue
Remove backup folders from multiple servers.
Read this article to learn how to use recursion to simply the task of creating multiple levels of fo...
script for backup files
Restore of red gate backup files using a SQL Script