Is it 2gig combined or 2 GB each...
Thanks
hi,
"newbie" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:A4A3D7B1-4B75-47F0-9DAE-B93DE9C0DA8B@.microsoft.com...
> Is it 2gig combined or 2 GB each...
>
2gb of data file per each database.. log file not included
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
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Thursday, February 16, 2012
Capacity of DB
Hi,
We have an old version (well one year) of MSDE in which all databases are
limited to a capacity of 2 gig (per database). If have heard that there might
be a new version of MSDE in which the Databases capacity would be at 8 gig
(per database).
My question is : Is this a fact or a rumor. And if it is true that the newer
version of MSDE gives the posibility to have 8 gig databases. What is the
version of MSDE that gives such a capacity for batabases.
Thanks for your help
Stéphane Pelletier
SQL Express is based on SQL 2005 and is a replacement for MSDE. It will be
limited to 4gb per database and should be released some time late this
summer.
MSDE 2000 is limited to 2gb per database.
-Andrew
"Stphane Pelletier" <Stphane Pelletier@.discussions.microsoft.com> wrote in
message news:F0F18AA2-F738-4415-81C6-54E89EB2796D@.microsoft.com...
> Hi,
> We have an old version (well one year) of MSDE in which all databases are
> limited to a capacity of 2 gig (per database). If have heard that there
might
> be a new version of MSDE in which the Databases capacity would be at 8 gig
> (per database).
> My question is : Is this a fact or a rumor. And if it is true that the
newer
> version of MSDE gives the posibility to have 8 gig databases. What is the
> version of MSDE that gives such a capacity for batabases.
> Thanks for your help
> Stphane Pelletier
|||Many thanks
"Andrew Robinson" wrote:
> SQL Express is based on SQL 2005 and is a replacement for MSDE. It will be
> limited to 4gb per database and should be released some time late this
> summer.
> MSDE 2000 is limited to 2gb per database.
> -Andrew
> "Stéphane Pelletier" <Stphane Pelletier@.discussions.microsoft.com> wrote in
> message news:F0F18AA2-F738-4415-81C6-54E89EB2796D@.microsoft.com...
> might
> newer
>
>
We have an old version (well one year) of MSDE in which all databases are
limited to a capacity of 2 gig (per database). If have heard that there might
be a new version of MSDE in which the Databases capacity would be at 8 gig
(per database).
My question is : Is this a fact or a rumor. And if it is true that the newer
version of MSDE gives the posibility to have 8 gig databases. What is the
version of MSDE that gives such a capacity for batabases.
Thanks for your help
Stéphane Pelletier
SQL Express is based on SQL 2005 and is a replacement for MSDE. It will be
limited to 4gb per database and should be released some time late this
summer.
MSDE 2000 is limited to 2gb per database.
-Andrew
"Stphane Pelletier" <Stphane Pelletier@.discussions.microsoft.com> wrote in
message news:F0F18AA2-F738-4415-81C6-54E89EB2796D@.microsoft.com...
> Hi,
> We have an old version (well one year) of MSDE in which all databases are
> limited to a capacity of 2 gig (per database). If have heard that there
might
> be a new version of MSDE in which the Databases capacity would be at 8 gig
> (per database).
> My question is : Is this a fact or a rumor. And if it is true that the
newer
> version of MSDE gives the posibility to have 8 gig databases. What is the
> version of MSDE that gives such a capacity for batabases.
> Thanks for your help
> Stphane Pelletier
|||Many thanks
"Andrew Robinson" wrote:
> SQL Express is based on SQL 2005 and is a replacement for MSDE. It will be
> limited to 4gb per database and should be released some time late this
> summer.
> MSDE 2000 is limited to 2gb per database.
> -Andrew
> "Stéphane Pelletier" <Stphane Pelletier@.discussions.microsoft.com> wrote in
> message news:F0F18AA2-F738-4415-81C6-54E89EB2796D@.microsoft.com...
> might
> newer
>
>
Sunday, February 12, 2012
cant upsize from access to MSDE 2000 (urgentish :p)
Hi guys
Having a problem with MSDE. I'm trying to upsize an Access database to MSDE.
I'm fairly new to all this SQLServer malarkey, so bear with me.
I've setup MSDE with the default Instance name (what is the default instance
name?) and a good SAPWD. Used to the /qb+ switch to install from the command
line - if I don't, the installation just seems to die half way through.
Now then, when I try and upsize my access db, i tell it to "create a new
database" and then it gives me a new dialog with Which server, login,
password etc. I'm not entirely sure what to put in here though. What's the
LoginID? I haven't created one (as far as i know).
I've tried MSSQL and 80 (both directories in Prog Files\SQL Server), but i
keep getting the same error (18452), telling me that login failed for user.
Reason: not associated with a trusted SQL server connection.
What am I doing wrong? Have I missed something? Any help greatly appreciated!
Cheers
Dan
hi Dan,
"Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
news:83F5ED5F-0F4A-43BC-AE40-1A57B907F9F1@.microsoft.com...
> Hi guys
> Having a problem with MSDE. I'm trying to upsize an Access database to
MSDE.
> I'm fairly new to all this SQLServer malarkey, so bear with me.
> I've setup MSDE with the default Instance name (what is the default
instance
> name?) and a good SAPWD. Used to the /qb+ switch to install from the
command
> line - if I don't, the installation just seems to die half way through.
please add the
/L*v "c:\...\Log.txt"
commandline parameter to the setup.exe bootstrap installer, in order to log
the installation (quite 2mb textual log) for troubleshooting...
did nt understand if you succesfully installed MSDE or not.. =;-D
> Now then, when I try and upsize my access db, i tell it to "create a new
> database" and then it gives me a new dialog with Which server, login,
> password etc. I'm not entirely sure what to put in here though. What's the
> LoginID? I haven't created one (as far as i know).
> I've tried MSSQL and 80 (both directories in Prog Files\SQL Server), but i
> keep getting the same error (18452), telling me that login failed for
user.
> Reason: not associated with a trusted SQL server connection.
> What am I doing wrong? Have I missed something? Any help greatly
appreciated!
here seems you succesfully got it... MSDE is installed..
MSDE installs by default only granting WindowsNT (trusted) authentication...
you have to manually change this setting..
please have a look at
http://support.microsoft.com/default...b;en-us;285097 for further
info on how to modify this behaviour both at install time and later...
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
|||Hiya
Thanks for, I had a look at the article and did what it suggested with the
Registry. That's prevented it from asking me for a username and password.
However, when I do it now.. I'm getting an "overflow" error. Any ideas on
that one?
Thanks again for your help so far!
Cheers
Dan
"Andrea Montanari" wrote:
> hi Dan,
> "Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
> news:83F5ED5F-0F4A-43BC-AE40-1A57B907F9F1@.microsoft.com...
> MSDE.
> instance
> command
> please add the
> /L*v "c:\...\Log.txt"
> commandline parameter to the setup.exe bootstrap installer, in order to log
> the installation (quite 2mb textual log) for troubleshooting...
> did nt understand if you succesfully installed MSDE or not.. =;-D
> user.
> appreciated!
> here seems you succesfully got it... MSDE is installed..
> MSDE installs by default only granting WindowsNT (trusted) authentication...
> you have to manually change this setting..
> please have a look at
> http://support.microsoft.com/default...b;en-us;285097 for further
> info on how to modify this behaviour both at install time and later...
> --
> 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
>
|||hi Dan,
"Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
news:855B1269-ED3F-4E70-B734-476F38DA4307@.microsoft.com...
> Hiya
> Thanks for, I had a look at the article and did what it suggested with the
> Registry. That's prevented it from asking me for a username and password.
> However, when I do it now.. I'm getting an "overflow" error. Any ideas on
> that one?
please have a look at
http://support.microsoft.com/default...;EN-US;Q237980
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
Having a problem with MSDE. I'm trying to upsize an Access database to MSDE.
I'm fairly new to all this SQLServer malarkey, so bear with me.
I've setup MSDE with the default Instance name (what is the default instance
name?) and a good SAPWD. Used to the /qb+ switch to install from the command
line - if I don't, the installation just seems to die half way through.
Now then, when I try and upsize my access db, i tell it to "create a new
database" and then it gives me a new dialog with Which server, login,
password etc. I'm not entirely sure what to put in here though. What's the
LoginID? I haven't created one (as far as i know).
I've tried MSSQL and 80 (both directories in Prog Files\SQL Server), but i
keep getting the same error (18452), telling me that login failed for user.
Reason: not associated with a trusted SQL server connection.
What am I doing wrong? Have I missed something? Any help greatly appreciated!
Cheers
Dan
hi Dan,
"Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
news:83F5ED5F-0F4A-43BC-AE40-1A57B907F9F1@.microsoft.com...
> Hi guys
> Having a problem with MSDE. I'm trying to upsize an Access database to
MSDE.
> I'm fairly new to all this SQLServer malarkey, so bear with me.
> I've setup MSDE with the default Instance name (what is the default
instance
> name?) and a good SAPWD. Used to the /qb+ switch to install from the
command
> line - if I don't, the installation just seems to die half way through.
please add the
/L*v "c:\...\Log.txt"
commandline parameter to the setup.exe bootstrap installer, in order to log
the installation (quite 2mb textual log) for troubleshooting...
did nt understand if you succesfully installed MSDE or not.. =;-D
> Now then, when I try and upsize my access db, i tell it to "create a new
> database" and then it gives me a new dialog with Which server, login,
> password etc. I'm not entirely sure what to put in here though. What's the
> LoginID? I haven't created one (as far as i know).
> I've tried MSSQL and 80 (both directories in Prog Files\SQL Server), but i
> keep getting the same error (18452), telling me that login failed for
user.
> Reason: not associated with a trusted SQL server connection.
> What am I doing wrong? Have I missed something? Any help greatly
appreciated!
here seems you succesfully got it... MSDE is installed..
MSDE installs by default only granting WindowsNT (trusted) authentication...
you have to manually change this setting..
please have a look at
http://support.microsoft.com/default...b;en-us;285097 for further
info on how to modify this behaviour both at install time and later...
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
|||Hiya
Thanks for, I had a look at the article and did what it suggested with the
Registry. That's prevented it from asking me for a username and password.
However, when I do it now.. I'm getting an "overflow" error. Any ideas on
that one?
Thanks again for your help so far!
Cheers
Dan
"Andrea Montanari" wrote:
> hi Dan,
> "Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
> news:83F5ED5F-0F4A-43BC-AE40-1A57B907F9F1@.microsoft.com...
> MSDE.
> instance
> command
> please add the
> /L*v "c:\...\Log.txt"
> commandline parameter to the setup.exe bootstrap installer, in order to log
> the installation (quite 2mb textual log) for troubleshooting...
> did nt understand if you succesfully installed MSDE or not.. =;-D
> user.
> appreciated!
> here seems you succesfully got it... MSDE is installed..
> MSDE installs by default only granting WindowsNT (trusted) authentication...
> you have to manually change this setting..
> please have a look at
> http://support.microsoft.com/default...b;en-us;285097 for further
> info on how to modify this behaviour both at install time and later...
> --
> 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
>
|||hi Dan,
"Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
news:855B1269-ED3F-4E70-B734-476F38DA4307@.microsoft.com...
> Hiya
> Thanks for, I had a look at the article and did what it suggested with the
> Registry. That's prevented it from asking me for a username and password.
> However, when I do it now.. I'm getting an "overflow" error. Any ideas on
> that one?
please have a look at
http://support.microsoft.com/default...;EN-US;Q237980
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
can't upgrade msde sp4
i'm trying to upgrade to sp4 using the following command:
<setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
UPGRADEPWD=password /L*v C:\MSDELog.log>
it starts, then stops, without giving me an error.
Please help!!
hi,
ak9408 wrote:
> i'm trying to upgrade to sp4 using the following command:
> <setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
> UPGRADEPWD=password /L*v C:\MSDELog.log>
> it starts, then stops, without giving me an error.
> Please help!!
inspect the C:\MSDELog.log text file for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
<setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
UPGRADEPWD=password /L*v C:\MSDELog.log>
it starts, then stops, without giving me an error.
Please help!!
hi,
ak9408 wrote:
> i'm trying to upgrade to sp4 using the following command:
> <setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
> UPGRADEPWD=password /L*v C:\MSDELog.log>
> it starts, then stops, without giving me an error.
> Please help!!
inspect the C:\MSDELog.log text file for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)