Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

Create SQL JOB to backup database and schedule it

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.

 

 

 

Total article views: 1977 | Views in the last 30 days: 2
 
Related Articles
FORUM

TSM Backup Shedule doesn't start

TSM Backup Shedule doesn't start

FORUM

backup

backup

FORUM

Backup

Backup

BLOG

Active August posts

I've started a blog to write down and track my personal goals: The Goal Keeping DBA Since Active A...

FORUM

Backups dbs

backups

Tags
 
Contribute