I'm trying to use a maintenance plan to backup my thing (Data + Log) on MSDE
The Data Backup work well, But I always have a error when trying to backup
the log... (Backup can not be performed on database 'GesTex'. This sub task
is ignored.)

I have observed that upgrading a Win98 machine to 2000 or XP will break
MSDE, this was pretty-much expected but my question is what the most
graceful way to repair/reinstall MSDE is?  It seems like a real mess.
Thanks in advance for your help!!

can someone please help me find any documents on this question or answer the
question please.
Thanks in advance
Ray

Hi NG
We have experienced that the LDF file grow out of proportions. In Microsoft
Knowledge Base we have found some descriptions on how to shrink the file.
Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE

i install microsoft MSDE on one machine it work fine on that machine but
when i am trying to connect from other machine by giving osql -U
"Username" -S "ServerName" and password but it give me error message Sql
server does not exist"

I have Windows 2003 Enterprise server with SP1, and try install WSUS server.
Problem is it can't install WMSDE (SQL Server 2000 Desktop Engine)
http://www.team-novel.com/~zoner/errorlog1.txt
http://www.team-novel.com/~zoner/errorlog2.txt

Are there any optimizing utilities for MSDE that can cleanup and reclaim
space?
Thanks in advance,
JeffH

Does it make sense to use a 64 bit CPU with MSDE 2000? Or better: does MSDE
user it? I can´t find any hints.

i want to install MSDE (comes with windows embedded designer)
install stops with following event:
ERROR:
event 19011 source MSSQLServer

Does a default installation of MSDE listen for connections on TCP/IP port
1433 by default or do I need to explicitly turn the TCP/IP listener on using
svrnetcn.exe?
(I'm using W2kR4 (v5.00.2195) and MSDE v8.000.761)

I downloaded MSDE from microsoft yesterday but I have been having alot of
problems setting it up. I started the install process with the following code
from te MSDN site:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<my

Dear Sir
I am using the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), i would
like to know if the search feature MS Search is supported.
Thanks in Advance

After purposefully removing the builtin\administrator from sql server on my
msde (msm based) installation I get the following error:
SQLServerAgent could not be started (reason: Unable to connect to server
'SERVER\INSTANCENAME'; SQLServerAgent cannot start).

using WINXP PRO SP2, MSDE and VS.NET 2003
When I attempt to "Step Into Stored Procedure" from VS ServerExplorer pane,
I get the following error message:
Cannot debug stored procedures because the SQL Server database is not setup

Am trying to backup to a network drive as the other machine has loads of
space.
Am using:-
BACKUP database TO DISK='\\myserver\backup\database.bak'