My clients are reporting they cannot connect to the msde database using my
application - generic failed to connect message.
My software application installs the MSDE. Their computer is a brand new
machine with XP-sp2 installed. The sp2 is not an upgrade. We have only
seen this phenomena with a machine where we cannot uninstall sp2. On
machines we can, our application can connect. On most (to all) machines
where we install xp-sp2 ourselves there is no problem.
Any ideas?
Check wheter the firewall of the XPs opened up the port to connect to the
msde, if not open up.
For a fast try deactivate the firewallfor checking, if its working open up
dedicated ports.
HTH, Jens Smeyer
http://www.sqlserver2005.de
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> schrieb im Newsbeitrag
news:u6h0w7TQFHA.3596@.TK2MSFTNGP15.phx.gbl...
> My clients are reporting they cannot connect to the msde database using my
> application - generic failed to connect message.
> My software application installs the MSDE. Their computer is a brand new
> machine with XP-sp2 installed. The sp2 is not an upgrade. We have only
> seen this phenomena with a machine where we cannot uninstall sp2. On
> machines we can, our application can connect. On most (to all) machines
> where we install xp-sp2 ourselves there is no problem.
> Any ideas?
>
|||Did all that.
What could be different about a machine pre-loaded with xp-sp2?
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:%23Pbrs%23TQFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Check wheter the firewall of the XPs opened up the port to connect to the
> msde, if not open up.
> For a fast try deactivate the firewallfor checking, if its working open up
> dedicated ports.
>
> HTH, Jens Smeyer
> --
> http://www.sqlserver2005.de
> --
>
> "Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> schrieb im
> Newsbeitrag news:u6h0w7TQFHA.3596@.TK2MSFTNGP15.phx.gbl...
>
Showing posts with label software. Show all posts
Showing posts with label software. Show all posts
Wednesday, March 28, 2012
MSDE sp3a & XP-sp2
My clients are reporting they cannot connect to the msde database using my
application - generic failed to connect message.
My software application installs the MSDE. Their computer is a brand new
machine with XP-sp2 installed. The sp2 is not an upgrade. We have only
seen this phenomena with a machine where we cannot uninstall sp2. On
machines we can, our application can connect. On most (to all) machines
where we install xp-sp2 ourselves there is no problem.
Any ideas?Check wheter the firewall of the XPs opened up the port to connect to the
msde, if not open up.
For a fast try deactivate the firewallfor checking, if its working open up
dedicated ports.
HTH, Jens Smeyer
http://www.sqlserver2005.de
--
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> schrieb im Newsbeitrag
news:u6h0w7TQFHA.3596@.TK2MSFTNGP15.phx.gbl...
> My clients are reporting they cannot connect to the msde database using my
> application - generic failed to connect message.
> My software application installs the MSDE. Their computer is a brand new
> machine with XP-sp2 installed. The sp2 is not an upgrade. We have only
> seen this phenomena with a machine where we cannot uninstall sp2. On
> machines we can, our application can connect. On most (to all) machines
> where we install xp-sp2 ourselves there is no problem.
> Any ideas?
>|||Did all that.
What could be different about a machine pre-loaded with xp-sp2'
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:%23Pbrs%23TQFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Check wheter the firewall of the XPs opened up the port to connect to the
> msde, if not open up.
> For a fast try deactivate the firewallfor checking, if its working open up
> dedicated ports.
>
> HTH, Jens Smeyer
> --
> http://www.sqlserver2005.de
> --
>
> "Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> schrieb im
> Newsbeitrag news:u6h0w7TQFHA.3596@.TK2MSFTNGP15.phx.gbl...
>
application - generic failed to connect message.
My software application installs the MSDE. Their computer is a brand new
machine with XP-sp2 installed. The sp2 is not an upgrade. We have only
seen this phenomena with a machine where we cannot uninstall sp2. On
machines we can, our application can connect. On most (to all) machines
where we install xp-sp2 ourselves there is no problem.
Any ideas?Check wheter the firewall of the XPs opened up the port to connect to the
msde, if not open up.
For a fast try deactivate the firewallfor checking, if its working open up
dedicated ports.
HTH, Jens Smeyer
http://www.sqlserver2005.de
--
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> schrieb im Newsbeitrag
news:u6h0w7TQFHA.3596@.TK2MSFTNGP15.phx.gbl...
> My clients are reporting they cannot connect to the msde database using my
> application - generic failed to connect message.
> My software application installs the MSDE. Their computer is a brand new
> machine with XP-sp2 installed. The sp2 is not an upgrade. We have only
> seen this phenomena with a machine where we cannot uninstall sp2. On
> machines we can, our application can connect. On most (to all) machines
> where we install xp-sp2 ourselves there is no problem.
> Any ideas?
>|||Did all that.
What could be different about a machine pre-loaded with xp-sp2'
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:%23Pbrs%23TQFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Check wheter the firewall of the XPs opened up the port to connect to the
> msde, if not open up.
> For a fast try deactivate the firewallfor checking, if its working open up
> dedicated ports.
>
> HTH, Jens Smeyer
> --
> http://www.sqlserver2005.de
> --
>
> "Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> schrieb im
> Newsbeitrag news:u6h0w7TQFHA.3596@.TK2MSFTNGP15.phx.gbl...
>
Monday, March 26, 2012
msde security...........................
I have a business directory software done in vb.net and sqlserver .We are
using msde for distribution purpose .The problem we are facing is about the
security of the data . The cd goes to common man and we are concerned about
the security of the data.Is there any option where we can ensure that the
database cannot be opened by the user . please help
..Urgent.........................
If by "common man" you mean that the database is installed on each
person's computer in their own MSDE instance, then the answer is no,
you can't prevent them from getting at the data because they are a
system administrator on that instance. If the database is located on a
server, then it is possible to implement a more robust security scheme
since users can be prevented from accessing the physical files and
from connecting as system administrators.
--Mary
On Thu, 8 Sep 2005 13:33:01 -0700, "techiebose"
<techiebose@.discussions.microsoft.com> wrote:
>I have a business directory software done in vb.net and sqlserver .We are
>using msde for distribution purpose .The problem we are facing is about the
>security of the data . The cd goes to common man and we are concerned about
>the security of the data.Is there any option where we can ensure that the
>database cannot be opened by the user . please help
>.Urgent.........................
sql
using msde for distribution purpose .The problem we are facing is about the
security of the data . The cd goes to common man and we are concerned about
the security of the data.Is there any option where we can ensure that the
database cannot be opened by the user . please help
..Urgent.........................
If by "common man" you mean that the database is installed on each
person's computer in their own MSDE instance, then the answer is no,
you can't prevent them from getting at the data because they are a
system administrator on that instance. If the database is located on a
server, then it is possible to implement a more robust security scheme
since users can be prevented from accessing the physical files and
from connecting as system administrators.
--Mary
On Thu, 8 Sep 2005 13:33:01 -0700, "techiebose"
<techiebose@.discussions.microsoft.com> wrote:
>I have a business directory software done in vb.net and sqlserver .We are
>using msde for distribution purpose .The problem we are facing is about the
>security of the data . The cd goes to common man and we are concerned about
>the security of the data.Is there any option where we can ensure that the
>database cannot be opened by the user . please help
>.Urgent.........................
sql
MSDE Redistributable rights
Hi,
I'm developping a software that use's an SQL Server database. I think to distrubute the MSDE with my application that I sold to users. I read the EULA and the discussion group and I don't see the answer for this.
I break the EULA?
Thanks, Oscar.
hi Oscar
"Osca Gil" <Osca Gil@.discussions.microsoft.com> ha scritto nel messaggio
news:B0F21901-13D1-46DA-AD52-1F34E96C98E0@.microsoft.com...
> Hi,
> I'm developping a software that use's an SQL Server database. I think to
distrubute the
>MSDE with my application that I sold to users. I read the EULA and the
discussion group
> and I don't see the answer for this.
> I break the EULA?
no... you don't, but please register at
http://www.microsoft.com/sql/msde/ho...stregister.asp to be entitled
for distribution rights...
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
I'm developping a software that use's an SQL Server database. I think to distrubute the MSDE with my application that I sold to users. I read the EULA and the discussion group and I don't see the answer for this.
I break the EULA?
Thanks, Oscar.
hi Oscar
"Osca Gil" <Osca Gil@.discussions.microsoft.com> ha scritto nel messaggio
news:B0F21901-13D1-46DA-AD52-1F34E96C98E0@.microsoft.com...
> Hi,
> I'm developping a software that use's an SQL Server database. I think to
distrubute the
>MSDE with my application that I sold to users. I read the EULA and the
discussion group
> and I don't see the answer for this.
> I break the EULA?
no... you don't, but please register at
http://www.microsoft.com/sql/msde/ho...stregister.asp to be entitled
for distribution rights...
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
Wednesday, March 21, 2012
MSDE Opinions
My software currently runs on Access 2000 Engine. The database is 600 MB and
I can have up to 10 users (6 constantly). I currently run a terminal server
to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
Is MSDE an option for my setup?
Would I need a second Database server?
Do I need to go all the way up to SQL 2000?
Our software company tells me that MSDE only can handle 10 connections. I
have read that that is not true. Are they basically trying to sell me full
blown SQL for nothing?
Opions greatly appreciated.
Chris
"Chris Blackwelder" <Chris Blackwelder@.discussions.microsoft.com> wrote in
message news:A1F1F198-3357-4657-A0F4-0F2EA7F2F84D@.microsoft.com...
| My software currently runs on Access 2000 Engine. The database is 600 MB and
| I can have up to 10 users (6 constantly). I currently run a terminal server
| to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
|
| Is MSDE an option for my setup?
Yes.
| Would I need a second Database server?
No.
| Do I need to go all the way up to SQL 2000?
No.
|
| Our software company tells me that MSDE only can handle 10 connections.
Where did they get 10 from? That is a toatly made up number. 5 and 8 are at
least in the docs, but you can exceed them. I have tested heavy loads up to 26
and then my P2-333 server couldn't cope.
I
| have read that that is not true. Are they basically trying to sell me full
| blown SQL for nothing?
Yes, but don't be mad at them. My guess is they don't know better unless they
have load tested it themselvs. MS dosn't allow anyone to publish benchmarks and
there is no reason for MS to advertise them.
|
| Opions greatly appreciated.
I belive MSDE can handle just as much as Enterprise or any other flavor of SQL,
unless you need more than 2Gig of data or 4 CPUs. Here is my tests
http://fox.wikis.com/wc.dll?Wiki~MSD...ks~SoftwareEng
Carl K
sql
I can have up to 10 users (6 constantly). I currently run a terminal server
to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
Is MSDE an option for my setup?
Would I need a second Database server?
Do I need to go all the way up to SQL 2000?
Our software company tells me that MSDE only can handle 10 connections. I
have read that that is not true. Are they basically trying to sell me full
blown SQL for nothing?
Opions greatly appreciated.
Chris
"Chris Blackwelder" <Chris Blackwelder@.discussions.microsoft.com> wrote in
message news:A1F1F198-3357-4657-A0F4-0F2EA7F2F84D@.microsoft.com...
| My software currently runs on Access 2000 Engine. The database is 600 MB and
| I can have up to 10 users (6 constantly). I currently run a terminal server
| to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
|
| Is MSDE an option for my setup?
Yes.
| Would I need a second Database server?
No.
| Do I need to go all the way up to SQL 2000?
No.
|
| Our software company tells me that MSDE only can handle 10 connections.
Where did they get 10 from? That is a toatly made up number. 5 and 8 are at
least in the docs, but you can exceed them. I have tested heavy loads up to 26
and then my P2-333 server couldn't cope.
I
| have read that that is not true. Are they basically trying to sell me full
| blown SQL for nothing?
Yes, but don't be mad at them. My guess is they don't know better unless they
have load tested it themselvs. MS dosn't allow anyone to publish benchmarks and
there is no reason for MS to advertise them.
|
| Opions greatly appreciated.
I belive MSDE can handle just as much as Enterprise or any other flavor of SQL,
unless you need more than 2Gig of data or 4 CPUs. Here is my tests
http://fox.wikis.com/wc.dll?Wiki~MSD...ks~SoftwareEng
Carl K
sql
MSDE not keeping an ALTER modifcation
Hi Everyone,
Today i faced the following issue : An MSDE Database I had been working
on in the morning in order to be able to upgrade our software, with
the statement:
Through Osql :
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
'PMI_Operations under 200Mb'
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb...please wait while increasing'
3)ALTER DATABASE [PMI_Operations] MODIFY FILE (NAME =
N'PMI_Operations', SIZE = 200)
'PMI_Operations under 200Mb...please wait while increasing'
1)
It worked fine.
I came back to the box in the afternoon, after rush hour, and did same
test again (
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
expecting it to not display the print message, but it did !! I had to
run the ALTER again.
What could have caused my morning ALTER to be discarded by the
Afternoon ?
Thanks for any help you can bring
Rgards
hi,
Frogbeef wrote:
> expecting it to not display the print message, but it did !! I had to
> run the ALTER again.
> What could have caused my morning ALTER to be discarded by the
> Afternoon ?
do you have a scheduled job to "shrink" databases?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
Today i faced the following issue : An MSDE Database I had been working
on in the morning in order to be able to upgrade our software, with
the statement:
Through Osql :
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
'PMI_Operations under 200Mb'
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb...please wait while increasing'
3)ALTER DATABASE [PMI_Operations] MODIFY FILE (NAME =
N'PMI_Operations', SIZE = 200)
'PMI_Operations under 200Mb...please wait while increasing'
1)
It worked fine.
I came back to the box in the afternoon, after rush hour, and did same
test again (
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
expecting it to not display the print message, but it did !! I had to
run the ALTER again.
What could have caused my morning ALTER to be discarded by the
Afternoon ?
Thanks for any help you can bring
Rgards
hi,
Frogbeef wrote:
> expecting it to not display the print message, but it did !! I had to
> run the ALTER again.
> What could have caused my morning ALTER to be discarded by the
> Afternoon ?
do you have a scheduled job to "shrink" databases?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
Monday, March 19, 2012
MSDE manager?
Hi there,
Does anyone know of any good software I can use for managing MSDE database?
Regards/
Jtanfor msde tools chcek the following :
shusheng - has a nice asp solutions that works quite well.
- look on the web for a download site
DbaMGR2K - a simple but nice db manager, the links is :
www.asql.biz/dbamgr.shmt
I'll think these tools should get you on your way!
Regards|||Check out dbWidget by Yazoo Software at
http://www.yazoosoft.com
dbWidget is a client database tool that works with MSDE,
SQL Server, Sybase, MySQL, and Oracle databases, all from
one product.
info@.yazoosoft.com|||A free tool can be found here:
http://www.aspenterprisemanager.com/
Anyway should be a lot of this kind of tool here:
http://www.sourceforge.net
Does anyone know of any good software I can use for managing MSDE database?
Regards/
Jtanfor msde tools chcek the following :
shusheng - has a nice asp solutions that works quite well.
- look on the web for a download site
DbaMGR2K - a simple but nice db manager, the links is :
www.asql.biz/dbamgr.shmt
I'll think these tools should get you on your way!
Regards|||Check out dbWidget by Yazoo Software at
http://www.yazoosoft.com
dbWidget is a client database tool that works with MSDE,
SQL Server, Sybase, MySQL, and Oracle databases, all from
one product.
info@.yazoosoft.com|||A free tool can be found here:
http://www.aspenterprisemanager.com/
Anyway should be a lot of this kind of tool here:
http://www.sourceforge.net
MSDE Management Tools
Hi all
Has anyone used the MSDE Manager Program from Vale Software? I am chasing
any reviews, thoughts and praise/criticism of the software. I have the
trial version and it appears to be ok, just wondering if there are any known
bugs etc.
Also, are there many other SQL Server/MSDE management tools (similar to
Enterprise Manager) on the market. I am developing some off the shelf
software and was hoping to make use of MSDE to lower costs (current software
version implemented in Access but looking for a client/server
implementation). Unfortunately due to the nature of our clients we need
something nice to manage the database/s, specifically a tool that includes
the maintenance plan wizard/feature of Enterprise Manager.> Also, are there many other SQL Server/MSDE management tools (similar to
> Enterprise Manager) on the market.
http://www.aspfaq.com/2442
Has anyone used the MSDE Manager Program from Vale Software? I am chasing
any reviews, thoughts and praise/criticism of the software. I have the
trial version and it appears to be ok, just wondering if there are any known
bugs etc.
Also, are there many other SQL Server/MSDE management tools (similar to
Enterprise Manager) on the market. I am developing some off the shelf
software and was hoping to make use of MSDE to lower costs (current software
version implemented in Access but looking for a client/server
implementation). Unfortunately due to the nature of our clients we need
something nice to manage the database/s, specifically a tool that includes
the maintenance plan wizard/feature of Enterprise Manager.> Also, are there many other SQL Server/MSDE management tools (similar to
> Enterprise Manager) on the market.
http://www.aspfaq.com/2442
Monday, March 12, 2012
MSDE log file grown to 7 gig.
We have a software program that uses MSDE and the log file
is currently at 7 gigabytes in size which is abnormal.
When I do a backup using the softwares utility the backup
is only about 12 meg but when i restore to a fresh install
of windows the log file is right back at 7 gigabytes.
Whats wrong with the MSDE and how do it shrink/correct
this?
hi John,
"John P." <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:02fb01c4ec23$aed1ebe0$3a01280a@.phx.gbl
> We have a software program that uses MSDE and the log file
> is currently at 7 gigabytes in size which is abnormal.
> When I do a backup using the softwares utility the backup
> is only about 12 meg but when i restore to a fresh install
> of windows the log file is right back at 7 gigabytes.
> Whats wrong with the MSDE and how do it shrink/correct
> this?
please have a look at MVP SQL Server Tibor Karaszi excellnt article on how
(and eventutally when) to shrink the transaction log at
http://www.karaszi.com/sqlserver/info_dont_shrink.asp ; the article also
contains links to Microsoft Knowledge Base to HOW TO articles to perform
correct backup/shrink operation
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
|||Also, make sure that the recovery mode is set to simple, for the database
the log is growing for, if you are not doing transaction log backups.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:33aucqF3pm2sjU1@.individual.net...
> hi John,
> "John P." <anonymous@.discussions.microsoft.com> ha scritto nel
> messaggio news:02fb01c4ec23$aed1ebe0$3a01280a@.phx.gbl
> please have a look at MVP SQL Server Tibor Karaszi excellnt article on how
> (and eventutally when) to shrink the transaction log at
> http://www.karaszi.com/sqlserver/info_dont_shrink.asp ; the article also
> contains links to Microsoft Knowledge Base to HOW TO articles to perform
> correct backup/shrink operation
> --
> 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
>
|||hi Derrick
"Derrick Leggett" <derrickleggett@.yahoo.com> ha scritto nel messaggio
news:%23x$S3rG7EHA.1292@.TK2MSFTNGP10.phx.gbl
> Also, make sure that the recovery mode is set to simple, for the
> database the log is growing for, if you are not doing transaction log
> backups.
about simple recovery model, I would not be that fast in changing it and I'd
consider my whole recovery strategy...
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
|||
He obviously needs to do that. Until he does though, there is no reason
to have the database in simple recovery mode. He then has a constant
maintenance nightmare and something extra to worry about. He should set it
to simple, figure out what he's doing, then reapproach the situation.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:33dedaF3t60usU1@.individual.net...
> hi Derrick
> "Derrick Leggett" <derrickleggett@.yahoo.com> ha scritto nel messaggio
> news:%23x$S3rG7EHA.1292@.TK2MSFTNGP10.phx.gbl
> about simple recovery model, I would not be that fast in changing it and
I'd
> consider my whole recovery strategy...
> --
> 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
>
is currently at 7 gigabytes in size which is abnormal.
When I do a backup using the softwares utility the backup
is only about 12 meg but when i restore to a fresh install
of windows the log file is right back at 7 gigabytes.
Whats wrong with the MSDE and how do it shrink/correct
this?
hi John,
"John P." <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:02fb01c4ec23$aed1ebe0$3a01280a@.phx.gbl
> We have a software program that uses MSDE and the log file
> is currently at 7 gigabytes in size which is abnormal.
> When I do a backup using the softwares utility the backup
> is only about 12 meg but when i restore to a fresh install
> of windows the log file is right back at 7 gigabytes.
> Whats wrong with the MSDE and how do it shrink/correct
> this?
please have a look at MVP SQL Server Tibor Karaszi excellnt article on how
(and eventutally when) to shrink the transaction log at
http://www.karaszi.com/sqlserver/info_dont_shrink.asp ; the article also
contains links to Microsoft Knowledge Base to HOW TO articles to perform
correct backup/shrink operation
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
|||Also, make sure that the recovery mode is set to simple, for the database
the log is growing for, if you are not doing transaction log backups.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:33aucqF3pm2sjU1@.individual.net...
> hi John,
> "John P." <anonymous@.discussions.microsoft.com> ha scritto nel
> messaggio news:02fb01c4ec23$aed1ebe0$3a01280a@.phx.gbl
> please have a look at MVP SQL Server Tibor Karaszi excellnt article on how
> (and eventutally when) to shrink the transaction log at
> http://www.karaszi.com/sqlserver/info_dont_shrink.asp ; the article also
> contains links to Microsoft Knowledge Base to HOW TO articles to perform
> correct backup/shrink operation
> --
> 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
>
|||hi Derrick
"Derrick Leggett" <derrickleggett@.yahoo.com> ha scritto nel messaggio
news:%23x$S3rG7EHA.1292@.TK2MSFTNGP10.phx.gbl
> Also, make sure that the recovery mode is set to simple, for the
> database the log is growing for, if you are not doing transaction log
> backups.
about simple recovery model, I would not be that fast in changing it and I'd
consider my whole recovery strategy...
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
|||
He obviously needs to do that. Until he does though, there is no reasonto have the database in simple recovery mode. He then has a constant
maintenance nightmare and something extra to worry about. He should set it
to simple, figure out what he's doing, then reapproach the situation.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:33dedaF3t60usU1@.individual.net...
> hi Derrick
> "Derrick Leggett" <derrickleggett@.yahoo.com> ha scritto nel messaggio
> news:%23x$S3rG7EHA.1292@.TK2MSFTNGP10.phx.gbl
> about simple recovery model, I would not be that fast in changing it and
I'd
> consider my whole recovery strategy...
> --
> 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 liciense
was that MSDE is a free distribute software and have not
access limitation for the number of the user?
where i can find the more license infor for MSDE
thanks in advance
Try http://www.microsoft.com/sql/msde/default.asp and
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Regards,
John
"How" <how_world@.hotmail.com> wrote in message
news:914401c4334f$ee4f8bc0$a501280a@.phx.gbl...
> was that MSDE is a free distribute software and have not
> access limitation for the number of the user?
> where i can find the more license infor for MSDE
> thanks in advance
access limitation for the number of the user?
where i can find the more license infor for MSDE
thanks in advance
Try http://www.microsoft.com/sql/msde/default.asp and
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Regards,
John
"How" <how_world@.hotmail.com> wrote in message
news:914401c4334f$ee4f8bc0$a501280a@.phx.gbl...
> was that MSDE is a free distribute software and have not
> access limitation for the number of the user?
> where i can find the more license infor for MSDE
> thanks in advance
Monday, February 20, 2012
MSDE exchange
hi there,
How do i have a server side code/software that will connect all the field of
my exchange server to a MSDE database? i need custom fields and all address
fields? i need it to be a link if pos?
dorling
In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes
>hi there,
>How do i have a server side code/software that will connect all the field of
>my exchange server to a MSDE database? i need custom fields and all address
>fields? i need it to be a link if pos?
>dorling
One simple answer is to use Forms in the Public Folders. Using Outlook
you can design and Publish these forms using templates and adding your
own custom fields as you go. You don't need MSDE or any other database
for that matter.
If you really need to hook Exchange into a backend database like MSDE
then the next real step would be to right your own plugin / extension
for Outlook. This would enable you to tie the two together but requires
learning more than T-SQL.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
thanks for that, is there some code/software or a web site that i could use
to help me, hook Exchange into a backend database like MSDE? i want the data
to be live/link not copy if possible in to the Database?
Jonathan
"Andrew D. Newbould" wrote:
> In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> One simple answer is to use Forms in the Public Folders. Using Outlook
> you can design and Publish these forms using templates and adding your
> own custom fields as you go. You don't need MSDE or any other database
> for that matter.
> If you really need to hook Exchange into a backend database like MSDE
> then the next real step would be to right your own plugin / extension
> for Outlook. This would enable you to tie the two together but requires
> learning more than T-SQL.
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||It depends on the programming language you want to use. However, try
these sites out for starters as they cover more than one programming
language:
Planet Source Code - http://www.pscode.com
Developers Dex - http://www.codecomments.com
Developer Fusion - http://www.developerfusion.com
The Code Project - http://www.codeproject.com
Source Forge - http://www.sourceforge.net
Kind Regards,
Andrew.
In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>thanks for that, is there some code/software or a web site that i could use
>to help me, hook Exchange into a backend database like MSDE? i want the data
>to be live/link not copy if possible in to the Database?
>Jonathan
>"Andrew D. Newbould" wrote:
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
I am going to be builting this apps in VB6!!
Jonathan
"Andrew D. Newbould" wrote:
> It depends on the programming language you want to use. However, try
> these sites out for starters as they cover more than one programming
> language:
> Planet Source Code - http://www.pscode.com
> Developers Dex - http://www.codecomments.com
> Developer Fusion - http://www.developerfusion.com
> The Code Project - http://www.codeproject.com
> Source Forge - http://www.sourceforge.net
> Kind Regards,
> Andrew.
>
> In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||Then also check out these other good sites:
VB Net - http://vbnet.mvps.org
VB City - http://www.vbcity.com
VB IP - http://www.vbip.com
Kind Regards,
Andrew
In message <D1A6DB20-A3B8-4A77-ADEA-3A423B54D664@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>I am going to be builting this apps in VB6!!
>Jonathan
>"Andrew D. Newbould" wrote:
<Snip>
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
How do i have a server side code/software that will connect all the field of
my exchange server to a MSDE database? i need custom fields and all address
fields? i need it to be a link if pos?
dorling
In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes
>hi there,
>How do i have a server side code/software that will connect all the field of
>my exchange server to a MSDE database? i need custom fields and all address
>fields? i need it to be a link if pos?
>dorling
One simple answer is to use Forms in the Public Folders. Using Outlook
you can design and Publish these forms using templates and adding your
own custom fields as you go. You don't need MSDE or any other database
for that matter.
If you really need to hook Exchange into a backend database like MSDE
then the next real step would be to right your own plugin / extension
for Outlook. This would enable you to tie the two together but requires
learning more than T-SQL.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
thanks for that, is there some code/software or a web site that i could use
to help me, hook Exchange into a backend database like MSDE? i want the data
to be live/link not copy if possible in to the Database?
Jonathan
"Andrew D. Newbould" wrote:
> In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> One simple answer is to use Forms in the Public Folders. Using Outlook
> you can design and Publish these forms using templates and adding your
> own custom fields as you go. You don't need MSDE or any other database
> for that matter.
> If you really need to hook Exchange into a backend database like MSDE
> then the next real step would be to right your own plugin / extension
> for Outlook. This would enable you to tie the two together but requires
> learning more than T-SQL.
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||It depends on the programming language you want to use. However, try
these sites out for starters as they cover more than one programming
language:
Planet Source Code - http://www.pscode.com
Developers Dex - http://www.codecomments.com
Developer Fusion - http://www.developerfusion.com
The Code Project - http://www.codeproject.com
Source Forge - http://www.sourceforge.net
Kind Regards,
Andrew.
In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>thanks for that, is there some code/software or a web site that i could use
>to help me, hook Exchange into a backend database like MSDE? i want the data
>to be live/link not copy if possible in to the Database?
>Jonathan
>"Andrew D. Newbould" wrote:
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
I am going to be builting this apps in VB6!!
Jonathan
"Andrew D. Newbould" wrote:
> It depends on the programming language you want to use. However, try
> these sites out for starters as they cover more than one programming
> language:
> Planet Source Code - http://www.pscode.com
> Developers Dex - http://www.codecomments.com
> Developer Fusion - http://www.developerfusion.com
> The Code Project - http://www.codeproject.com
> Source Forge - http://www.sourceforge.net
> Kind Regards,
> Andrew.
>
> In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||Then also check out these other good sites:
VB Net - http://vbnet.mvps.org
VB City - http://www.vbcity.com
VB IP - http://www.vbip.com
Kind Regards,
Andrew
In message <D1A6DB20-A3B8-4A77-ADEA-3A423B54D664@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>I am going to be builting this apps in VB6!!
>Jonathan
>"Andrew D. Newbould" wrote:
<Snip>
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
Subscribe to:
Posts (Atom)