norewind on SQL 2k backup

I could use some help on this one.
I have an SQL 2k server set up to do a scheduled backup to a tape drive.
The backup is part of a maintenance plan if it matters. It is backing up
around 50 databases, and between each backup, the server dismounts and
remounts the tape. This ends up creating a huge delay, and a backup can
easily run for 10 to 15 hours. I also think that it rewinds the tape during
each dismount/mount and overwrites the previous database. I found some
information about using the "norewind" option to fix this, but I have no
idea how to use it. The maintenance plan creates a job with one step, and
it runs the command:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
B02C357F-6496-4B99-B899-4F4D57EE789B -Rpt "E:\BACKUP_LOG\ALL CNS
DATA4.txt" -DelTxtRpt 4WEEKS -WriteHistory -VrfyBackup -BkUpMedia
TAPE -BkUpDB "\\.\Tape0" '
Can I simply specify '-NOREWIND' as an option here? If not, how or where
would I specify this setting?
I'd really appreciate any information. Thanks in advance for any help.
JasonI never do a SQL backup to tape. Why does the server dismount and remount
the tape? Why don't we make it simple: use SQL to backup DB to disk; backup
these backup files to tape using NT backup or BackupExec (not the SQL module
of BackupExec). Depend on the amount of data you need to backup to tape,
you will a DLT tape, a SDLT tape, or a tape library. We have an HP
StorageWorks MSL5026. It backs up SQL backup files with the rate =335MB/minute.
"j" <jason1@.thecolossal.com> wrote in message
news:AdW_a.3486$S_.2867@.fed1read01...
> I could use some help on this one.
> I have an SQL 2k server set up to do a scheduled backup to a tape drive.
> The backup is part of a maintenance plan if it matters. It is backing up
> around 50 databases, and between each backup, the server dismounts and
> remounts the tape. This ends up creating a huge delay, and a backup can
> easily run for 10 to 15 hours. I also think that it rewinds the tape
during
> each dismount/mount and overwrites the previous database. I found some
> information about using the "norewind" option to fix this, but I have no
> idea how to use it. The maintenance plan creates a job with one step, and
> it runs the command:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> B02C357F-6496-4B99-B899-4F4D57EE789B -Rpt "E:\BACKUP_LOG\ALL CNS
> DATA4.txt" -DelTxtRpt 4WEEKS -WriteHistory -VrfyBackup -BkUpMedia
> TAPE -BkUpDB "\\.\Tape0" '
> Can I simply specify '-NOREWIND' as an option here? If not, how or where
> would I specify this setting?
>
> I'd really appreciate any information. Thanks in advance for any help.
> Jason
>|||That suggestion has come up at work. I think that's what we'll end up
doing. It should make life a lot easier.
Thanks,
Jason
"Flicker" <hthan@.superioraccess.com> wrote in message
news:OqLvOV1YDHA.2308@.TK2MSFTNGP12.phx.gbl...
> I never do a SQL backup to tape. Why does the server dismount and remount
> the tape? Why don't we make it simple: use SQL to backup DB to disk;
backup
> these backup files to tape using NT backup or BackupExec (not the SQL
module
> of BackupExec). Depend on the amount of data you need to backup to tape,
> you will a DLT tape, a SDLT tape, or a tape library. We have an HP
> StorageWorks MSL5026. It backs up SQL backup files with the rate => 335MB/minute.
>
> "j" <jason1@.thecolossal.com> wrote in message
> news:AdW_a.3486$S_.2867@.fed1read01...
> > I could use some help on this one.
> >
> > I have an SQL 2k server set up to do a scheduled backup to a tape drive.
> > The backup is part of a maintenance plan if it matters. It is backing
up
> > around 50 databases, and between each backup, the server dismounts and
> > remounts the tape. This ends up creating a huge delay, and a backup can
> > easily run for 10 to 15 hours. I also think that it rewinds the tape
> during
> > each dismount/mount and overwrites the previous database. I found some
> > information about using the "norewind" option to fix this, but I have no
> > idea how to use it. The maintenance plan creates a job with one step,
and
> > it runs the command:
> >
> > EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> > B02C357F-6496-4B99-B899-4F4D57EE789B -Rpt "E:\BACKUP_LOG\ALL CNS
> > DATA4.txt" -DelTxtRpt 4WEEKS -WriteHistory -VrfyBackup -BkUpMedia
> > TAPE -BkUpDB "\\.\Tape0" '
> >
> > Can I simply specify '-NOREWIND' as an option here? If not, how or
where
> > would I specify this setting?
> >
> >
> > I'd really appreciate any information. Thanks in advance for any help.
> >
> > Jason
> >
> >
>