MSDE & Windows XP

I was wondering if I can install SQL Developers Edition over the MSDE?
I'm working for this guy and he has a database installed on Windows XP. I
think it's MSDE (we'll call it the1st computer), it had no interface. I
installed the SQL Developers Edition on another Windows XP (we'll call this
the 2nd computer) to manipulate the backup jobs. The nightly backups are
successful on the 1st computer. But on the 2nd computer I cannot get the
backup jobs to backup to drive C of the 2nd computer. In other words I can
only see the 1st computer drive C when I want to set up a backup job.
If the above is not clear, try reading below:
Here is what I want to achieve. Nightly backup onto the 2nd computer and
restore that data using a backup job. I know it's possible but here is my
problem. When set up a job to back up to the 2nd computer the job fails and
gives me Device is not available.
I tried sharing the folder
I tried sp_AddDevice
I tried hard coding the path and used the IP address.
Any suggestions.
Mo
hi,
"MoNews" <moone@.charter.net> ha scritto nel messaggio
news:10gu6q94qbvva08@.corp.supernews.com...
> I was wondering if I can install SQL Developers Edition over the MSDE?
yes, you can... up to 16 instances of different editions, at different
service pack levels can be technically installed on the same computer..
but only one of them can be the default instance, while all the others will
be named instances...

> I'm working for this guy and he has a database installed on Windows XP. I
> think it's MSDE (we'll call it the1st computer), it had no interface. I
> installed the SQL Developers Edition on another Windows XP (we'll call
this
> the 2nd computer) to manipulate the backup jobs. The nightly backups are
> successful on the 1st computer. But on the 2nd computer I cannot get the
> backup jobs to backup to drive C of the 2nd computer. In other words I
can
> only see the 1st computer drive C when I want to set up a backup job.
> If the above is not clear, try reading below:
> Here is what I want to achieve. Nightly backup onto the 2nd computer and
> restore that data using a backup job. I know it's possible but here is my
> problem. When set up a job to back up to the 2nd computer the job fails
and
> gives me Device is not available.
> I tried sharing the folder
> I tried sp_AddDevice
> I tried hard coding the path and used the IP address.
the windows account running 1st computer SQL Server Agent must have enought
privileges to handle 2nd computer file system...
so you have to provide a windows account who has been granted enought
privileges on both PCs...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply