Creating SQL Server CE database on server

Is it possible to create a SQL server CE 2.0 database on a desktop
running SQL Server? We're currently building the database on the device
itself but would like to prebuild it on the server and just send it
down. Microsoft describes something in:
http://support.microsoft.com/default.aspx?scid=kb;en-us;301217&sd=tech
This really seems like just a hack.
You can create the databases on the PPC emulator, so I didn't think it
would be too far of a stretch to create them on the server.the really great news is you can create it on the desktop/server in SQL
2005! However, the method described in the link you have provided is the way
I have always done it.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chris Karcher" <ckarcher@.mail.utexas.edu> wrote in message
news:ehb1c8$7k9$1@.geraldo.cc.utexas.edu...
> Is it possible to create a SQL server CE 2.0 database on a desktop running
> SQL Server? We're currently building the database on the device itself
> but would like to prebuild it on the server and just send it down.
> Microsoft describes something in:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;301217&sd=tech
> This really seems like just a hack.
> You can create the databases on the PPC emulator, so I didn't think it
> would be too far of a stretch to create them on the server.|||Yea, it's really cool that SQL Mobile (Everywhere?) can be used on all
platforms. It's just that we aren't quite ready to switch yet..
Hilary Cotter wrote:
> the really great news is you can create it on the desktop/server in SQL
> 2005! However, the method described in the link you have provided is the way
> I have always done it.
>

Creating new backup device

I need to create a new backup device. I have installed a
USB drive, and would like to backup a database to it.
However, SQL Server can only see one of the drives
available on the machine when I try to create the new
device. How can I make a new backup device to a different
drive letter?
Can you try creating a dump device using sp_addumpdevice from Query Analyzer
and see if that solves the problem? See SQL Server Books Online for more
information.--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"onemoreshot" <anonymous@.discussions.microsoft.com> wrote in message
news:7fa201c484ae$4c09e7b0$a401280a@.phx.gbl...
I need to create a new backup device. I have installed a
USB drive, and would like to backup a database to it.
However, SQL Server can only see one of the drives
available on the machine when I try to create the new
device. How can I make a new backup device to a different
drive letter?
|||In other words, it can't be done through Enterprise
Manager? Thanks .

>--Original Message--
>Can you try creating a dump device using sp_addumpdevice
from Query Analyzer
>and see if that solves the problem? See SQL Server Books
Online for more
>information.--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"onemoreshot" <anonymous@.discussions.microsoft.com> wrote
in message
>news:7fa201c484ae$4c09e7b0$a401280a@.phx.gbl...
>I need to create a new backup device. I have installed a
>USB drive, and would like to backup a database to it.
>However, SQL Server can only see one of the drives
>available on the machine when I try to create the new
>device. How can I make a new backup device to a different
>drive letter?
>
>.
>
|||If it is a proper drive, then you should be able to do it in EM also. I am
just trying to narrow down the problem, by trying this in Query Analyzer.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:8be201c48592$81ec8f60$a401280a@.phx.gbl...
In other words, it can't be done through Enterprise
Manager? Thanks .

>--Original Message--
>Can you try creating a dump device using sp_addumpdevice
from Query Analyzer
>and see if that solves the problem? See SQL Server Books
Online for more
>information.--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"onemoreshot" <anonymous@.discussions.microsoft.com> wrote
in message
>news:7fa201c484ae$4c09e7b0$a401280a@.phx.gbl...
>I need to create a new backup device. I have installed a
>USB drive, and would like to backup a database to it.
>However, SQL Server can only see one of the drives
>available on the machine when I try to create the new
>device. How can I make a new backup device to a different
>drive letter?
>
>.
>