Re: Backup Automatically..

From: Steve Thompson (SteveThompson@nomail.please)
Date: 04/07/03 

From: "Steve Thompson" <SteveThompson@nomail.please>
Date: Mon, 7 Apr 2003 11:36:11 -0400

"Maryam Rezvani" <mrezvani@khazar2.com> wrote in message
news:#PZrRqN$CHA.1156@TK2MSFTNGP12.phx.gbl...
> I've SQL Server 2000 installed on win NT
> and I want to find a way to backup a DB
> on CDRW Driver,
> now I backup my DB by creating a job which
> saves related file on harddisk periodically,
> and then manually write it on CDRW,
> can I change my way and directly rewrite information
> on CRRW?

You should be able to specify a TSQL BACKUP statement to specify the CDRW
drive, then use SQL Server Agent to schedule the task.

Steve

Relevant Pages

  • Re: Backup Automatically..
    ... BACKUP DATABASE TO DISK='E:\DATABASEBACKUPFILE.BAK' ... is the volume of your CDRW, however, I'm not sure you'll be able to do ... >> You should be able to specify a TSQL BACKUP statement to specify the ...
    (microsoft.public.sqlserver.security)
  • Re: Backup Automatically..
    ... >> and I want to find a way to backup a DB ... >> on CDRW Driver, ... > You should be able to specify a TSQL BACKUP statement to specify the CDRW ...
    (microsoft.public.sqlserver.security)
  • Re: How to do a backup with sqlmaint in a different directory
    ... Go to database maintenance plans in enterprise manager and edit your plan ... There's an option to specify the directory where you want your ... Co-Author SQL Server 2000 Programming by Example ... > Somobody know how to say to sqlmaint in which directory do the backup to ...
    (microsoft.public.sqlserver.server)
  • RE: SBS Backup problems
    ... search for *SQL* there a Microsoft SQL Server folder located under C:\Program ... > From the backup log, I find the following error message. ... > - You back up data from a volume that contains a Microsoft SQL Server ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)