Backup to CD-ROM 
Author Message
 Backup to CD-ROM
This isn't really a SQL Server question, but maybe someone here knows
anyway.

I'm looking for a way to be able to back up a SQL Server 7 database
directly to a CD-ROM.  As it is, my client has to do a backup to hard
disk, then use their CD-R software (Adaptec CD Creator) to copy the
backup file to CD.  I'd like to eliminate the second step, so the
backups can be fully automated.  Is this possible, and if so, how?

The computers are running Windows 98, if that matters.

Thanks,

Allan



Tue, 22 Feb 2005 15:47:43 GMT
 Backup to CD-ROM

Hi

I don't have much of an idea about what is available... but it seems
to me that if they can not do automated backup then they need new
software to back up the other things on the system. Once they have
this then they can backup the server to disk and then to CD without
intervention.

One possibility you may wish to explore is the software like

http://www.veritas.com/products/category/ProductAddOnDetail.jhtml?pro...

which means that you could back up to the CD as if it was a hard
drive, what I don't know is if it will work!

John


Quote:
>This isn't really a SQL Server question, but maybe someone here knows
>anyway.

>I'm looking for a way to be able to back up a SQL Server 7 database
>directly to a CD-ROM.  As it is, my client has to do a backup to hard
>disk, then use their CD-R software (Adaptec CD Creator) to copy the
>backup file to CD.  I'd like to eliminate the second step, so the
>backups can be fully automated.  Is this possible, and if so, how?

>The computers are running Windows 98, if that matters.

>Thanks,

>Allan



Tue, 22 Feb 2005 19:00:19 GMT
 Backup to CD-ROM
Allan,

There are packetwrite software tools, that make a
cdrw drive being a legal read/write part of the filesystem
instead of readonly.
Once having installed this you just pass the directory/drive
of the cdrw to the backupcommand.
cheers,

      robert



Tue, 22 Feb 2005 19:05:37 GMT
 Backup to CD-ROM



Quote:

> which means that you could back up to the CD as if it was a hard
> drive, what I don't know is if it will work!

I use DirectCd software, that enables the CD-Rom to be written accessing it
with a standard drive letter such as "H:".

I made a Sql-Server 7.0 backup directly on CD, some time ago.

What I don't know is if DirectCd can be launched on system boot or at least
at login.
Each time I use it, I start it manually and I've to press one or two "Next"
button to obtain my Cd-Rom as a drive letter.

Bye

Alberto



Tue, 22 Feb 2005 19:04:49 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Is there any database working with CD-ROM(CD-R,CD-RW)

2. Backups, scanning, video capturing all to CD-ROM!

3. Backups, scanning, video capturing all to CD-ROM!

4. Backups, scanning, video capturing all to CD-ROM!

5. Backups, scanning, video capturing all to CD-ROM!

6. Use CD-ROM as a backup device.

7. vfp 3.0 CD Rom Install, CD Label problem Win95

8. Using CD-R,CD-RW as Backup Device in Sql Server

9. Install SQL 6.5 remotely on machines without CD-ROM/SCSI controler

10. Can DB files stored in CD-ROM

11. XML Samples on SQL 2000 CD-ROM


 
Powered by phpBB® Forum Software