SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it cannot
use more than 3GB RAM under any circumstances, but it can be installed on a
server having more than 3GB total RAM; or, does that mean that it cannot be
installed or used on a server having more than 3GB RAM?
Hello,
You can install SQL Server workgroup edition ina machine with more than 3 GB
RAM and more than 2 CPU. But the limitation is SQL Server workgroup
edition can maximum use only 3 GB of RAM and 2 CPU.
http://www.microsoft.com/sql/editions/workgroup/sysreqs.mspx
Thanks
Hari
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?
|||The statement means that Workgroup Edition will only use up to 3GB memory,
even if the server has more available. It will run on a server with 4GB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?
Showing posts with label 3gb. Show all posts
Showing posts with label 3gb. Show all posts
Thursday, March 8, 2012
Can SQL Server 2005 Workgroup Ed be installed on a server with 4G
SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it cannot
use more than 3GB RAM under any circumstances, but it can be installed on a
server having more than 3GB total RAM; or, does that mean that it cannot be
installed or used on a server having more than 3GB RAM?Hello,
You can install SQL Server workgroup edition ina machine with more than 3 GB
RAM and more than 2 CPU. But the limitation is SQL Server workgroup
edition can maximum use only 3 GB of RAM and 2 CPU.
http://www.microsoft.com/sql/editions/workgroup/sysreqs.mspx
Thanks
Hari
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?|||The statement means that Workgroup Edition will only use up to 3GB memory,
even if the server has more available. It will run on a server with 4GB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?
use more than 3GB RAM under any circumstances, but it can be installed on a
server having more than 3GB total RAM; or, does that mean that it cannot be
installed or used on a server having more than 3GB RAM?Hello,
You can install SQL Server workgroup edition ina machine with more than 3 GB
RAM and more than 2 CPU. But the limitation is SQL Server workgroup
edition can maximum use only 3 GB of RAM and 2 CPU.
http://www.microsoft.com/sql/editions/workgroup/sysreqs.mspx
Thanks
Hari
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?|||The statement means that Workgroup Edition will only use up to 3GB memory,
even if the server has more available. It will run on a server with 4GB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?
Can SQL Server 2005 Workgroup Ed be installed on a server with 4G
SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it cannot
use more than 3GB RAM under any circumstances, but it can be installed on a
server having more than 3GB total RAM; or, does that mean that it cannot be
installed or used on a server having more than 3GB RAM?Hello,
You can install SQL Server workgroup edition ina machine with more than 3 GB
RAM and more than 2 CPU. But the limitation is SQL Server workgroup
edition can maximum use only 3 GB of RAM and 2 CPU.
http://www.microsoft.com/sql/editio...up/sysreqs.mspx
Thanks
Hari
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?|||The statement means that Workgroup Edition will only use up to 3GB memory,
even if the server has more available. It will run on a server with 4GB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?
use more than 3GB RAM under any circumstances, but it can be installed on a
server having more than 3GB total RAM; or, does that mean that it cannot be
installed or used on a server having more than 3GB RAM?Hello,
You can install SQL Server workgroup edition ina machine with more than 3 GB
RAM and more than 2 CPU. But the limitation is SQL Server workgroup
edition can maximum use only 3 GB of RAM and 2 CPU.
http://www.microsoft.com/sql/editio...up/sysreqs.mspx
Thanks
Hari
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?|||The statement means that Workgroup Edition will only use up to 3GB memory,
even if the server has more available. It will run on a server with 4GB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Harvey Hall" <HarveyHall@.discussions.microsoft.com> wrote in message
news:E12ACD19-E86F-4E8E-A088-25A42C3A0423@.microsoft.com...
> SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it
> cannot
> use more than 3GB RAM under any circumstances, but it can be installed on
> a
> server having more than 3GB total RAM; or, does that mean that it cannot
> be
> installed or used on a server having more than 3GB RAM?
Sunday, February 12, 2012
Can not shrink a Database!
Hi,
I am running SQL 2K
I have a DB that is 6GB.
out of that, 5.5GB is the Trans Log.
I did a backup of the Data and the log.
Now it shows 5.3GB unused, but I cant get that free space to go away!
When I creaded the DB it was 10MB? so I know that is not the problem
any ideas?
thanks George.George,
A log backup wont shrink the files, it would just empty it.To shrink the
files, use DBCC SHRINKFILE.More details here:
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"george d lake" <georgel@.valleyyellowpages.com> wrote in message
news:uf8dznzaDHA.2672@.tk2msftngp13.phx.gbl...
> Hi,
> I am running SQL 2K
> I have a DB that is 6GB.
> out of that, 5.5GB is the Trans Log.
> I did a backup of the Data and the log.
> Now it shows 5.3GB unused, but I cant get that free space to go away!
> When I creaded the DB it was 10MB? so I know that is not the problem
>
> any ideas?
> thanks George.
>|||Ok,
I ran this:
DBCC SHRINKFILE(SystemMon_Log, 140)
And got this:
Cannot shrink log file 2 (SystemMon_Log) because all logical log files are
in use.
(1 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:OOAParzaDHA.2344@.TK2MSFTNGP09.phx.gbl...
> George,
> A log backup wont shrink the files, it would just empty it.To shrink the
> files, use DBCC SHRINKFILE.More details here:
> INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
> http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "george d lake" <georgel@.valleyyellowpages.com> wrote in message
> news:uf8dznzaDHA.2672@.tk2msftngp13.phx.gbl...
> > Hi,
> > I am running SQL 2K
> > I have a DB that is 6GB.
> > out of that, 5.5GB is the Trans Log.
> > I did a backup of the Data and the log.
> > Now it shows 5.3GB unused, but I cant get that free space to go
away!
> > When I creaded the DB it was 10MB? so I know that is not the problem
> >
> >
> > any ideas?
> >
> > thanks George.
> >
> >
>|||Ok.
It worked!
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:OOAParzaDHA.2344@.TK2MSFTNGP09.phx.gbl...
> George,
> A log backup wont shrink the files, it would just empty it.To shrink the
> files, use DBCC SHRINKFILE.More details here:
> INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
> http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "george d lake" <georgel@.valleyyellowpages.com> wrote in message
> news:uf8dznzaDHA.2672@.tk2msftngp13.phx.gbl...
> > Hi,
> > I am running SQL 2K
> > I have a DB that is 6GB.
> > out of that, 5.5GB is the Trans Log.
> > I did a backup of the Data and the log.
> > Now it shows 5.3GB unused, but I cant get that free space to go
away!
> > When I creaded the DB it was 10MB? so I know that is not the problem
> >
> >
> > any ideas?
> >
> > thanks George.
> >
> >
>
I am running SQL 2K
I have a DB that is 6GB.
out of that, 5.5GB is the Trans Log.
I did a backup of the Data and the log.
Now it shows 5.3GB unused, but I cant get that free space to go away!
When I creaded the DB it was 10MB? so I know that is not the problem
any ideas?
thanks George.George,
A log backup wont shrink the files, it would just empty it.To shrink the
files, use DBCC SHRINKFILE.More details here:
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"george d lake" <georgel@.valleyyellowpages.com> wrote in message
news:uf8dznzaDHA.2672@.tk2msftngp13.phx.gbl...
> Hi,
> I am running SQL 2K
> I have a DB that is 6GB.
> out of that, 5.5GB is the Trans Log.
> I did a backup of the Data and the log.
> Now it shows 5.3GB unused, but I cant get that free space to go away!
> When I creaded the DB it was 10MB? so I know that is not the problem
>
> any ideas?
> thanks George.
>|||Ok,
I ran this:
DBCC SHRINKFILE(SystemMon_Log, 140)
And got this:
Cannot shrink log file 2 (SystemMon_Log) because all logical log files are
in use.
(1 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:OOAParzaDHA.2344@.TK2MSFTNGP09.phx.gbl...
> George,
> A log backup wont shrink the files, it would just empty it.To shrink the
> files, use DBCC SHRINKFILE.More details here:
> INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
> http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "george d lake" <georgel@.valleyyellowpages.com> wrote in message
> news:uf8dznzaDHA.2672@.tk2msftngp13.phx.gbl...
> > Hi,
> > I am running SQL 2K
> > I have a DB that is 6GB.
> > out of that, 5.5GB is the Trans Log.
> > I did a backup of the Data and the log.
> > Now it shows 5.3GB unused, but I cant get that free space to go
away!
> > When I creaded the DB it was 10MB? so I know that is not the problem
> >
> >
> > any ideas?
> >
> > thanks George.
> >
> >
>|||Ok.
It worked!
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:OOAParzaDHA.2344@.TK2MSFTNGP09.phx.gbl...
> George,
> A log backup wont shrink the files, it would just empty it.To shrink the
> files, use DBCC SHRINKFILE.More details here:
> INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
> http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "george d lake" <georgel@.valleyyellowpages.com> wrote in message
> news:uf8dznzaDHA.2672@.tk2msftngp13.phx.gbl...
> > Hi,
> > I am running SQL 2K
> > I have a DB that is 6GB.
> > out of that, 5.5GB is the Trans Log.
> > I did a backup of the Data and the log.
> > Now it shows 5.3GB unused, but I cant get that free space to go
away!
> > When I creaded the DB it was 10MB? so I know that is not the problem
> >
> >
> > any ideas?
> >
> > thanks George.
> >
> >
>
Subscribe to:
Posts (Atom)