MS SQL Server - Edit MSSQL scheduled backup

Author

Edit MSSQL scheduled backup

Candee

2006-02-18, 7:23 am

I created a recurring backup using the procedure below, but I can not find a
way to modify the schedule. Please help.

Thanks in advance

Microsoft SQL Enterprise Manager Version 8

Instructions:

How to create a database backup (Enterprise Manager)
To create a database backup

Expand a server group, and then expand a server.

Expand Databases, right-click the database, point to All Tasks, and then
click Backup Database.

In the Name box, type the backup set name. Optionally, in Description, type
a description of the backup set.

Under Backup, click Database - complete.

Under Destination, click Tape or Disk, and then specify a backup destination.
If no backup destinations appear, click Add to add an existing destination
or to create a new one.

Under Overwrite, do one of the following:
Click Append to media to append the backup to any existing backups on the
backup device.

Click Overwrite existing media to overwrite any existing backups on the
backup device.
Optionally, select the Schedule check box to schedule the backup operation
for later or periodic execution.

Optionally, click the Options tab and do one or more of the following:
Select the Verify backup upon completion check box to cause the backup to be
verified when backed up.

Select the Eject tape after backup check box to cause the tape to be ejected
when the backup operation has completed. Available only with tape devices.

Select the Check media set name and backup set expiration check box to cause
the backup media to be checked to prevent accidental overwrites. In Media set
name, type the name of the media to be used for the backup operation. Leave
blank when specifying only the backup set expiration.
If it is the first use of the backup media, or you want to change an
existing media label, under Media set labels, select the Initialize and label
media check box and type the media set name and media set description. The
media can be initialized and labeled only when overwriting the media.

Tibor Karaszi

2006-02-18, 9:23 am

EM created an SQL Server Agent job for you. You can edit that job.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Candee" <Candee@discussions.microsoft.com> wrote in message
news:5412EF5B-03C5-4DB6-92F1- 182FEA72DBEB@microso
ft.com...
>I created a recurring backup using the procedure below, but I can not find a
> way to modify the schedule. Please help.
>
> Thanks in advance
>
> Microsoft SQL Enterprise Manager Version 8
>
> Instructions:
>
> How to create a database backup (Enterprise Manager)
> To create a database backup
>
> Expand a server group, and then expand a server.
>
>
> Expand Databases, right-click the database, point to All Tasks, and then
> click Backup Database.
>
>
> In the Name box, type the backup set name. Optionally, in Description, type
> a description of the backup set.
>
>
> Under Backup, click Database - complete.
>
>
> Under Destination, click Tape or Disk, and then specify a backup destination.
> If no backup destinations appear, click Add to add an existing destination
> or to create a new one.
>
> Under Overwrite, do one of the following:
> Click Append to media to append the backup to any existing backups on the
> backup device.
>
>
> Click Overwrite existing media to overwrite any existing backups on the
> backup device.
> Optionally, select the Schedule check box to schedule the backup operation
> for later or periodic execution.
>
>
> Optionally, click the Options tab and do one or more of the following:
> Select the Verify backup upon completion check box to cause the backup to be
> verified when backed up.
>
>
> Select the Eject tape after backup check box to cause the tape to be ejected
> when the backup operation has completed. Available only with tape devices.
>
>
> Select the Check media set name and backup set expiration check box to cause
> the backup media to be checked to prevent accidental overwrites. In Media set
> name, type the name of the media to be used for the backup operation. Leave
> blank when specifying only the backup set expiration.
> If it is the first use of the backup media, or you want to change an
> existing media label, under Media set labels, select the Initialize and label
> media check box and type the media set name and media set description. The
> media can be initialized and labeled only when overwriting the media.
>
>
>

Sponsored Links