msde AlaptopND sql server on save

I have SQL Server Developer edition on my laptop. Want to install MSDE on
same laptop (so VB .NET 2003 will work.
Any issues here with two versions/inmstances of "SQL Server" on same box?
On Sat, 16 Apr 2005 13:11:28 -0700, rOBBY wrote:

>I have SQL Server Developer edition on my laptop. Want to install MSDE on
>same laptop (so VB .NET 2003 will work.
>Any issues here with two versions/inmstances of "SQL Server" on same box?
Hi Robby,
I have never tried it myself, but I *think* that it should work. Though
I can imagine your poor laptop having a hard time, attempting to serve
two memory-intensive applications. :-)
For a more authorative answer, I suggest you repeat your question in
microsoft.public.sqlserver.msde, or microsoft.public.sqlserver.setup.
This group (microsoft.public.sqlserver.mseq) is actually about English
Query, so most MSDE and setup experts don't hang around here.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

MSDE 2GB Limit

Hi
A Client has an MSDE install - checked by running @.@.version (clearly
says developer edition in the result text).
However the size of the data file is over 3GB, even allowing for empty
spaces the amount of data far exceeds 2GB. Pls explain?
The database was filled by regular insert statements.
Am 31 Oct 2005 04:14:49 -0800 schrieb yitzak:

> Hi
> A Client has an MSDE install - checked by running @.@.version (clearly
> says developer edition in the result text).
> However the size of the data file is over 3GB, even allowing for empty
> spaces the amount of data far exceeds 2GB. Pls explain?
> The database was filled by regular insert statements.
MSDE always shows "Desktop Engine" and not "Developer Edition"!
bye,
Helmut

MSDE 2000A EULA / SBS 2003 Web Edition

Hi. I'm a bit confused and wonder whether someone of you can give me some
more information on this.
The EULA for MSDE 2000A states that you cannot use MSDE for hosting
services. Does anyone know what this mean?
I'm running an ASP.Net application and would like to use MSDE as the backend
database. Does this fall into this category?
Or does it mean that if I'm an ISP, I'm not allowed to offer MSDE as a
feature on my hosting packages?
Also, it says that you're not allowed to install any applications on SBS
2003 Web Edition. Does MSDE fall into this category?
Thanks very much for your help!
Martin
Hi Martin,
If you plan on using Webserver I think you need the full version of SQL. As
for SBS webserver 2003 I think you mean Windows Webserver 2003, which is a
lower priced version of windows server with a limited feature set optimized
for webhosting and reducing the cost of server to make it more competitive
in that market place. If you are a programmer look into either the ISV
program or the Action pack program which will help you out with the software
required to setup the development environment.
Regards,
Jeff Loucks
Available Technology
Solutions For Professionals
www.availabletechnology.com
"Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
news:u$$6SFOcEHA.212@.TK2MSFTNGP12.phx.gbl...
> Hi. I'm a bit confused and wonder whether someone of you can give me some
> more information on this.
> The EULA for MSDE 2000A states that you cannot use MSDE for hosting
> services. Does anyone know what this mean?
> I'm running an ASP.Net application and would like to use MSDE as the
backend
> database. Does this fall into this category?
> Or does it mean that if I'm an ISP, I'm not allowed to offer MSDE as a
> feature on my hosting packages?
> Also, it says that you're not allowed to install any applications on SBS
> 2003 Web Edition. Does MSDE fall into this category?
> Thanks very much for your help!
> Martin
>
>
>

MSDE 2000 Release A Supported systems

The addendum to the Readme file for MSDE 2000 Release A states "MSDE 2000 Release A is supported on Microsoft Windows Server 2003, Web Edition".
Does this mean that it executes only under Windows 2000 Server 2003 ?
I am running Windows 2000 Pro, it doesnt work. Does anyone run MSDE 2000 Rel A under other windows versions?
Mark Ferguson
hi Mark,
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> ha scritto nel
messaggio news:F7D2BF11-BE8F-4AD7-B1AE-FAA334E68CE7@.microsoft.com...
> The addendum to the Readme file for MSDE 2000 Release A states "MSDE 2000
Release A is supported on Microsoft Windows Server 2003, Web Edition".
> Does this mean that it executes only under Windows 2000 Server 2003 ?
> I am running Windows 2000 Pro, it doesnt work. Does anyone run MSDE 2000
Rel
>A under other windows versions?
I think that extract shoul'd be intended as "Microsoft Windows Server 2003,
Web Edition can only run MSDE and not a full blown SQL Server edition"...
MSDE can be installed up to Win98 boxes, more system requirements at
http://www.microsoft.com/sql/msde/pr...fo/sysreqs.asp
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

MSDE 2000 and SQL Server 2000 Personal Edition Compatibility

Are there any compatibility issues between Microsoft SQL Desktop Edition and
SQL Server 2000 Personal Edition Compatibility.
I would like to install one packaged application that uses MSDE 2000 and a
second packaged application that uses SQL Server 2000 Personal Edition.
Both seem to be using MDAC 2.8
Thanks
I dont see that there is any problem as far as compatibility is concerned.

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

MSDE - Job Scheduling and Stored Procedures

Can MSDE run stored procedures? Does MSDE have the same job scheduling features that SQL Standard and Enterprise Edition have?
SR
Yes and yes.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SR" <mv2k_2003-news@.yahoo.com> wrote in message news:ALq0d.13990$QJ3.9851@.newssvr21.news.prodigy.c om...
Can MSDE run stored procedures? Does MSDE have the same job scheduling features that SQL Standard and Enterprise Edition have?
SR
|||yes and no.
The SQL Express does not have job scheduler on board.
regards
bav

MSDE

Hello
How do you use Enterprise Manager in MSDE. I got the
version of MSDE from Office XP Professional edition.
AsifEnterprise manager is not shipped with MSDE . The SQL Server 2000 Desktop
Engine does not include graphical management tools. You can manage instances
of the Desktop Engine from the SQL Server 2000 graphical tools if installed
with another edition of SQL Server.
Or use third party tools for MSDE
http://www.betav.com/Files/Content/Tools/tools.htm
--
-Vishal
"Asif" <asifjr@.hotmail.com> wrote in message
news:0ac801c35117$9dbfdb80$a601280a@.phx.gbl...
> Hello
> How do you use Enterprise Manager in MSDE. I got the
> version of MSDE from Office XP Professional edition.
> Asif

msdbdata.mdf file is over 5 GB, cannot shrink it

I have problem with my sql server developer edition.

I began reciving alerts regarding disk space, and found out that the msdb files are 5 GB!!! the data file is full, so I cannot shrink it, but the table usage shows only a few MB used by tables.

its not advisable to shrink the system dbs except tempdb,but in your case just check if any user tables are created in msdb if so just delete the same to free diskspace.... then try shrinking msdb but b4 shrinking ensure you have the latest backup of all the dbs....
|||

There are no user tables on this server.

It a local developer version, I use for development and small checks, there is no back up nither.

MSDB and PUBS Databases

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>|||MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>
>|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegroups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>

MSDB and PUBS Databases

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.
Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>
|||MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.
|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>
>
|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegr oups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>

MSDB and PUBS Databases

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Server.
We setup a SQL backup to run under SQL. We got the messages in the report.
It said "backup cannot be performed on database 'msdb'. This subtask is
ignored." and "Backup cannot be performed on database 'pubs'. This subtask
is ignored". Is it necessary to backup msdb and pubs databases? Thanks.MSDB stores all you job as well as replication information, so backin
this up can save you lot of time in a disastery case. Pubs is jut a
sample database, if you want to you can leave this out, as you can
download the creation script somewhere on the MSDN space of microsoft.
HTH, Jens Suessmeyer.|||Hi Diane
My guess is that this error is occurring when you try to back up the
transaction log of these databases, as they are in simple mode and the log
cannot be backed up.
Pubs is a sample database used in the documentation examples, and can be
easily rebuilt. It should never need to be backed up at all. MSDB should be
backed up so you can restore information about your tasks, jobs, alerts and
backup history. But you may be backing up the full database already and it
may only be the log backup that is failing.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Server. We setup a SQL backup to run under SQL. We got the messages in
> the report. It said "backup cannot be performed on database 'msdb'. This
> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
> This subtask is ignored". Is it necessary to backup msdb and pubs
> databases? Thanks.
>|||Thank you very much, Kalen for your prompt response.
Under Database Maintenance, a complete backup runs once a week and
transaction backup runs everyday. You are right. The error message comes
from the transaction log history. Do you suggest that I ignore the error
messages since I have a complete backup runs every week? I will uncheck the
backup for the PUBS database.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eyN$1mJOGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Diane
> My guess is that this error is occurring when you try to back up the
> transaction log of these databases, as they are in simple mode and the log
> cannot be backed up.
> Pubs is a sample database used in the documentation examples, and can be
> easily rebuilt. It should never need to be backed up at all. MSDB should
> be backed up so you can restore information about your tasks, jobs, alerts
> and backup history. But you may be backing up the full database already
> and it may only be the log backup that is failing.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:utYsaWJOGHA.2472@.TK2MSFTNGP11.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Server. We setup a SQL backup to run under SQL. We got the messages in
>> the report. It said "backup cannot be performed on database 'msdb'. This
>> subtask is ignored." and "Backup cannot be performed on database 'pubs'.
>> This subtask is ignored". Is it necessary to backup msdb and pubs
>> databases? Thanks.
>>
>
>|||Thanks for your prompt response, Jens. I just unchecked the backup for the
PUBS database. Thanks.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1140713647.322715.266680@.g47g2000cwa.googlegroups.com...
> MSDB stores all you job as well as replication information, so backin
> this up can save you lot of time in a disastery case. Pubs is jut a
> sample database, if you want to you can leave this out, as you can
> download the creation script somewhere on the MSDN space of microsoft.
> HTH, Jens Suessmeyer.
>