Msde and backup-restore

I'm using Msde on a PC with XP SP2 acting as "server" and accessing a
database on a PC with XP SP2 acting as "client". I can backup my database
from the "client" using UNC format
"\\client.computer.name\share.name\file.name.b kp" but when trying to restore
it from the "client" PC i get errors. Any ideas about how to restore the bkp
file to server pc from the client without having to copy the bkp file to the
server and perform the restore from there? Thanks
hi,
Dithom wrote:
> I'm using Msde on a PC with XP SP2 acting as "server" and accessing a
> database on a PC with XP SP2 acting as "client". I can backup my
> database from the "client" using UNC format
> "\\client.computer.name\share.name\file.name.b kp" but when trying to
> restore it from the "client" PC i get errors. Any ideas about how to
> restore the bkp file to server pc from the client without having to
> copy the bkp file to the server and perform the restore from there?
> Thanks
what kind of exception do you get?
actually if you can backup on a remote share you should be able to restore
from it too..
the account(s) running the SQL Server and SQL Server Agent must have enought
privileges on the remote share...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Access via the Network

I'm having a terrible time accessing an MSDE instance over the network.
sqlDMO's listAvailableSQLServers doesn't see the installed instance. I
installed the MSDE instance using setup.exe with the following command:
setup.exe disablenetworkprotocols=0 sapwd="<pwd>" securityMode=SQL
instanceName="<my instance name>"
No luck. So I thought I'd use the svrnetcn.exe utility to enable network
protocols since MSDE seems to be ignoring the command line. When I try to run
svrnetcn.exe, the screen flickers but the program never opens.
This *was* working several weeks ago. It quit working about the time I
installed Service Pack 2 for Windows XP on the box that was hosting this
server. Does anyone have any idea why this is happening to me? Any help
would be GREATLY appreciated.
Rob Reagan
rob@.digitallabsinc.com
hi Rob,
"Rob Reagan" <RobReagan@.discussions.microsoft.com> ha scritto nel messaggio
news:5B63E3CB-8307-49C8-ABC4-56B114893B1D@.microsoft.com...
> I'm having a terrible time accessing an MSDE instance over the network.
> sqlDMO's listAvailableSQLServers doesn't see the installed instance. I
> installed the MSDE instance using setup.exe with the following command:
> setup.exe disablenetworkprotocols=0 sapwd="<pwd>" securityMode=SQL
> instanceName="<my instance name>"
> No luck. So I thought I'd use the svrnetcn.exe utility to enable network
> protocols since MSDE seems to be ignoring the command line. When I try to
run
> svrnetcn.exe, the screen flickers but the program never opens.
> This *was* working several weeks ago. It quit working about the time I
> installed Service Pack 2 for Windows XP on the box that was hosting this
> server. Does anyone have any idea why this is happening to me? Any help
> would be GREATLY appreciated.
> Rob Reagan
> rob@.digitallabsinc.com
>
SP service pack 2 changed a lot of things regarding SQL Server connections
too..
I've not installed sp2 yet, but it's worth reading
http://support.microsoft.com/default.aspx?kbid=841249 and related links...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you so much! That's just the information I needed.
SP2 makes my PC so secure, not even my own applications can get through...
"Andrea Montanari" wrote:

> hi Rob,
> "Rob Reagan" <RobReagan@.discussions.microsoft.com> ha scritto nel messaggio
> news:5B63E3CB-8307-49C8-ABC4-56B114893B1D@.microsoft.com...
> run
> SP service pack 2 changed a lot of things regarding SQL Server connections
> too..
> I've not installed sp2 yet, but it's worth reading
> http://support.microsoft.com/default.aspx?kbid=841249 and related links...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

MSDE 2000 connectivity problem

Hi,
I have installed MSDE 2000 into my desktop machine.I can
connect from other machines to my desktop and accessing
databases using Query Analyser, Enterperise manager,
Profiler.but I didn't connect from ASP.NET application
using as "connectionstring".
Earlier it was worked.now its not working.
Send me your valuable reply ASAP.
Thanks and regards,
RafiqHow does your connection string look like?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rafiq" <anonymous@.discussions.microsoft.com> wrote in message
news:088801c3a9ab$02032c50$a401280a@.phx.gbl...
> Hi,
> I have installed MSDE 2000 into my desktop machine.I can
> connect from other machines to my desktop and accessing
> databases using Query Analyser, Enterperise manager,
> Profiler.but I didn't connect from ASP.NET application
> using as "connectionstring".
> Earlier it was worked.now its not working.
> Send me your valuable reply ASAP.
> Thanks and regards,
> Rafiq