Use CD-ROM as a backup device. 
Author Message
 Use CD-ROM as a backup device.
Dear all,

I'd like to use the CD-ROM as a backup device. How to configure in SQL
Server ? (I'm now using SQL Server version 6.5)

Best Regards,
Narin Ch.



Wed, 06 Nov 2002 03:00:00 GMT
 Use CD-ROM as a backup device.

Will this do it?

sp_create_removable (T-SQL)
Creates a removable media database. Creates three or more files (one for the system catalog tables,
one the transaction log, and one or more for the data tables) and places the database on those
files.

Syntax
















Is the physical name, including a fully qualified path, of the file that holds the system catalog

Is the size, in megabytes, of the file that holds the system catalog tables. syssize is int. The


Is the physical name, including a fully qualified path, of the file that contains the transaction

Is the size, in megabytes, of the file that contains the transaction log. logsize is int. The

Is the logical name of a file that contains the data tables. datalogical is sysname.
There must be from 1 through 16 data files. Usually, more than one data file is created when the
database is expected to be large and must be distributed on multiple disks.

Is the physical name, including a fully qualified path, of a file that contains data tables.

Is the size, in megabytes, of a file that contains data tables. datasize is int. The minimum
datasize is 1.
Return Code Values
0 (success) or 1 (failure)

Result Sets
None

Remarks
If you want to make a copy of your database on a removable media (such as a compact disc) and
distribute the database to other users, use this stored procedure.

Permissions
Only members of the sysadmin fixed server role can execute sp_create_removable.

Examples
This example creates the database inventory as a removable database.

sp_create_removable 'inventory',
  'invsys','c:\mssql7\data\invsys.mdf', 2,
  'invlog', 'c:\mssql7\data\invlog.ldf',4,
  'invdata','c:\mssql7\data\invdata.ndf',10

Quote:

>Dear all,

>I'd like to use the CD-ROM as a backup device. How to configure in SQL
>Server ? (I'm now using SQL Server version 6.5)

>Best Regards,
>Narin Ch.



Wed, 06 Nov 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

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

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

3. Backup to CD-ROM

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

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

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

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

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

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

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

11. Using Access from CD-ROM in multiuser mode?

12. Using the BDE from a CD-ROM


 
Powered by phpBB® Forum Software