Showing posts with label grow. Show all posts
Showing posts with label grow. Show all posts

Sunday, March 25, 2012

Database Size is not grow automatically

Hi all,
One of my Database Size is not grow automatically (auto grow is set ON in
that DB).Help me to resolve this problem
B.Saminathan
Software Engineer
California Software Co. Ltd.
Elnet Software City, Taramani,
Chennai 600 113
saminathanb@.calsoft.co.in
tel: 22541464Hi
How do you know ?:-)
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||If the thread that forced the autogrow times out it can roll back the growth
as well. Never rely on Autogrow. If you know you need space then manually
grow the files at a proper time. All data and log files should have plenty
of free space at all times for proper operation.
Andrew J. Kelly SQL MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||Hi,
See if the hard drives where you placed the MDF and LDF have enough space
based on the growth rate (MB or %) you specified.
EG:- If you specify 1 GB growth and if you do not have 1 GB free in hard
disk then auto grow will not happen.
Thanks
Hari
SQL Server MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>

Database Size is not grow automatically

Hi all,
One of my Database Size is not grow automatically (auto grow is set ON in
that DB).Help me to resolve this problem
B.Saminathan
Software Engineer
California Software Co. Ltd.
Elnet Software City, Taramani,
Chennai 600 113
saminathanb@.calsoft.co.in
tel: 22541464
Hi
How do you know ?:-)
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>
|||If the thread that forced the autogrow times out it can roll back the growth
as well. Never rely on Autogrow. If you know you need space then manually
grow the files at a proper time. All data and log files should have plenty
of free space at all times for proper operation.
Andrew J. Kelly SQL MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>
|||Hi,
See if the hard drives where you placed the MDF and LDF have enough space
based on the growth rate (MB or %) you specified.
EG:- If you specify 1 GB growth and if you do not have 1 GB free in hard
disk then auto grow will not happen.
Thanks
Hari
SQL Server MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>
sql

Database Size is not grow automatically

Hi all,
One of my Database Size is not grow automatically (auto grow is set ON in
that DB).Help me to resolve this problem
B.Saminathan
Software Engineer
California Software Co. Ltd.
Elnet Software City, Taramani,
Chennai 600 113
saminathanb@.calsoft.co.in
tel: 22541464Hi
How do you know ?:-)
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||If the thread that forced the autogrow times out it can roll back the growth
as well. Never rely on Autogrow. If you know you need space then manually
grow the files at a proper time. All data and log files should have plenty
of free space at all times for proper operation.
--
Andrew J. Kelly SQL MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||Hi,
See if the hard drives where you placed the MDF and LDF have enough space
based on the growth rate (MB or %) you specified.
EG:- If you specify 1 GB growth and if you do not have 1 GB free in hard
disk then auto grow will not happen.
Thanks
Hari
SQL Server MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>

Thursday, March 22, 2012

Database Size

Hi,
I have create Database with size 200 md and 40 mb for mdf and ldf
respectively (Fixed Size - not go grow or shrink) while creating database,
using wizard, little later i checked database size it became with default
size automatically.
How can I create database with Fixed size
Thanks
Mothi KannanIn sql Enterprise Manager right click your database and use the data and log
tabs to set the sizes. be sure to uncheck the autogrow stuff..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mothi" <Mothi@.discussions.microsoft.com> wrote in message
news:2AAF530A-5462-4E60-8D28-D76D7429DFC4@.microsoft.com...
> Hi,
> I have create Database with size 200 md and 40 mb for mdf and ldf
> respectively (Fixed Size - not go grow or shrink) while creating database,
> using wizard, little later i checked database size it became with default
> size automatically.
> How can I create database with Fixed size
> Thanks
> Mothi Kannan

Database Size

Hi,
I have create Database with size 200 md and 40 mb for mdf and ldf
respectively (Fixed Size - not go grow or shrink) while creating database,
using wizard, little later i checked database size it became with default
size automatically.
How can I create database with Fixed size
Thanks
Mothi KannanIn sql Enterprise Manager right click your database and use the data and log
tabs to set the sizes. be sure to uncheck the autogrow stuff..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mothi" <Mothi@.discussions.microsoft.com> wrote in message
news:2AAF530A-5462-4E60-8D28-D76D7429DFC4@.microsoft.com...
> Hi,
> I have create Database with size 200 md and 40 mb for mdf and ldf
> respectively (Fixed Size - not go grow or shrink) while creating database,
> using wizard, little later i checked database size it became with default
> size automatically.
> How can I create database with Fixed size
> Thanks
> Mothi Kannan

Wednesday, March 21, 2012

Database Size

Hi,
I have create Database with size 200 md and 40 mb for mdf and ldf
respectively (Fixed Size - not go grow or shrink) while creating database,
using wizard, little later i checked database size it became with default
size automatically.
How can I create database with Fixed size
Thanks
Mothi Kannan
In sql Enterprise Manager right click your database and use the data and log
tabs to set the sizes. be sure to uncheck the autogrow stuff..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mothi" <Mothi@.discussions.microsoft.com> wrote in message
news:2AAF530A-5462-4E60-8D28-D76D7429DFC4@.microsoft.com...
> Hi,
> I have create Database with size 200 md and 40 mb for mdf and ldf
> respectively (Fixed Size - not go grow or shrink) while creating database,
> using wizard, little later i checked database size it became with default
> size automatically.
> How can I create database with Fixed size
> Thanks
> Mothi Kannan