|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Backup database media
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Backup database media
|
|
| frank 2002-11-11, 12:23 am |
| Hello,
Have you any idea on the media of the database backup file?
Since my client want us to use the CD-RW as the backup device, I have never
heard of this kind of backup media before.
Configuration is SQL Server 2000 on Windows 2000 Server.
Thanks in advance
Frank
| |
| P. Ward 2002-11-11, 7:23 am |
| Frank
CD-RW is a rewritable CD format, in other words once a CD has been burnt to
it can be re-written to after mastering software has formatted the disk
correctly.
In order to use CD-RW as a medium to back up to, a dump device must be added
using the sp_addumpdevice stored procedure (or alternatively through SQL
Enterprise Manger Right click on a database then All Tasks | Backup
Database). Refer to sp_addumpdvice in SQL Server Books on Line.
eg. Use the following TSQL command in Query Analyser
sp_addumpdevice 'disk', 'NameOfBackupDevice', 'd:\test.bak'
To backup the Database use the following TSQL command in Query Analyser
backup database DatabaseName to NameOfBackupDevice
First however though ensure that you are able to write to the CD by dragging
and dropping a file through windows explorer to the CD-RW. If this fails
then the CD-RW needs to be formatted using mastering software such as Click
and Burn.
"frank" <frankw@qd.lucent.com> wrote in message
news:u6GjCXUiCHA.2380@tkmsftngp09...
> Hello,
> Have you any idea on the media of the database backup file?
> Since my client want us to use the CD-RW as the backup device, I have
never
> heard of this kind of backup media before.
> Configuration is SQL Server 2000 on Windows 2000 Server.
>
> Thanks in advance
> Frank
>
>
>
|
|
|
|
|