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 Bharat Panthee,
By using this script we can create Job for creating backup database.
The job will be automatically run in scheduled time.
In above script TESTDB is the db to be backedup.
'sa' is loginName.
E:\Backup\Database Backups\TESTDB is backup location.
@active_start_date=20101224,=>activity start date.@active_end_date=99991231,=>activity end date@active_start_time=200000,=>activity start time@active_end_time=235959=>activity end time.
TSM Backup Shedule doesn't start
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active A...