Create a removable database

I would like create a removable database, like dvd/cd-rom
I've read the follow help
- sp_create_removable
- sp_certify_removable
- sp_attach_db
- sp_attach_single_file_db
...
But when I try to attach my database, my Sql server "don't
see" my cd-rom drive.
:-((
Why ?
How can declare a Database on a removable support ?
Thank for any help.
JeeCee
I did this once a long time ago. If I remember correctly these where the
steps I used:
1) Created the database on disk and populated it.
2) I then detached the database
3) I then burned the mdf and ldf from the detached database to a cd-rom
4) I then reattached the database pointing to the physical files on the
cd-rom.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JeeCee" <nospam@.nospam> wrote in message
news:40fc3ffc$0$29378$626a14ce@.news.free.fr...
> I would like create a removable database, like dvd/cd-rom
> I've read the follow help
> - sp_create_removable
> - sp_certify_removable
> - sp_attach_db
> - sp_attach_single_file_db
> ...
> But when I try to attach my database, my Sql server "don't
> see" my cd-rom drive.
> :-((
> Why ?
> How can declare a Database on a removable support ?
> Thank for any help.
> JeeCee
>
|||I think you may find that it works better if you copy the .ldf file to disk.
Rick Sawtell
MCT, MCSD, MCDBA
RICHARD SAWTELL
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:OrhoV3dbEHA.3016@.tk2msftngp13.phx.gbl...
> I did this once a long time ago. If I remember correctly these where the
> steps I used:
> 1) Created the database on disk and populated it.
> 2) I then detached the database
> 3) I then burned the mdf and ldf from the detached database to a cd-rom
> 4) I then reattached the database pointing to the physical files on the
> cd-rom.
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "JeeCee" <nospam@.nospam> wrote in message
> news:40fc3ffc$0$29378$626a14ce@.news.free.fr...
>