Database is running slow after running DBCC Shrinkdatabase command

We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran
the DBCC Shrinkdatabase command last week. Now, the database is slow when I
open one of the work orders. Do you have any recommendation on how to fix
the slowness? Am I doing something incorrectly? I ran the following
commands under Query Analyzer. Thank you.
BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)Diane,
Just a guess...perhaps there is very little free space in the database and
the growth interval is small (i.e., 1MB) so the database continually grows
as new data is inserted. If this is the case, increase the size of the
database and the the growth setting. Degrading performance can also be
attributed to index fragmentation and out-of-date statistics.
HTH
Jerr
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ek4k5hgxFHA.1132@.TK2MSFTNGP10.phx.gbl...
> We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran
> the DBCC Shrinkdatabase command last week. Now, the database is slow when
> I open one of the work orders. Do you have any recommendation on how to
> fix the slowness? Am I doing something incorrectly? I ran the following
> commands under Query Analyzer. Thank you.
> BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
> GO
> DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)
>|||The shrinkdatabase command isn't very useful in my opinion.
You don't have much control over which files are being
shrunk to what size. Shrinking is typically something that
you would do ad hoc and for a specific file using shrinkfile
- after a run away transaction filled up the log, a database
where the log wasn't being backed up and the size became too
large, etc. The goal should be to size the files
appropriately, do regular log back ups to keep the log size
reasonable and avoid shrinking activities.
The slowness may or may not be related to having shrunk the
database last week. When you query the table, you would want
to monitor what is going on - checking for other activity
and locking/blocking by executing sp_who2 and querying the
sysprocesses table in the master database. And you'd want to
use something other than Enterprise Manager to view data in
tables - especially if it has a lot of data. Enterprise
Manager isn't necessarily a good tool to use for viewing or
manipulating data. Use Query Analyzer instead.
-Sue
On Fri, 30 Sep 2005 14:46:53 -0700, "Diane Walker"
<ett9300@.yahoo.com> wrote:
>We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran
>the DBCC Shrinkdatabase command last week. Now, the database is slow when I
>open one of the work orders. Do you have any recommendation on how to fix
>the slowness? Am I doing something incorrectly? I ran the following
>commands under Query Analyzer. Thank you.
>BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
>GO
>DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)
>|||Possibly autogrow as suggested or that indexes became fragmented due to the shrink:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:ek4k5hgxFHA.1132@.TK2MSFTNGP10.phx.gbl...
> We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran the DBCC Shrinkdatabase
> command last week. Now, the database is slow when I open one of the work orders. Do you have any
> recommendation on how to fix the slowness? Am I doing something incorrectly? I ran the following
> commands under Query Analyzer. Thank you.
> BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
> GO
> DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)
>sql

Database from 2000 Enterprise Edition to std

Hi, There,
I want move the database from 2000 Enterprise Edtion to 2000 Std, does Ms
sql support that and any special way required?
Thanks and regards
ShermaineShermaine,
backup and restore should be fine. The only things I can think of to look
out for are:
if you use distributed partitioned views you will have to change them
if you use indexed views, your related queries will need to have the
"noexpand" hint added.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||You can also try to do a detach and attach the database.
"xiaomei" wrote:

> Hi, There,
> I want move the database from 2000 Enterprise Edtion to 2000 Std, does Ms
> sql support that and any special way required?
>
> Thanks and regards
> Shermaine|||Thanks too much, Paul, Lucas. Have a nice weekend!! .
"Paul Ibison" wrote:

> Shermaine,
> backup and restore should be fine. The only things I can think of to look
> out for are:
> if you use distributed partitioned views you will have to change them
> if you use indexed views, your related queries will need to have the
> "noexpand" hint added.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>

Database from 2000 Enterprise Edition to std

Hi, There,
I want move the database from 2000 Enterprise Edtion to 2000 Std, does Ms
sql support that and any special way required?
Thanks and regards
Shermaine
Shermaine,
backup and restore should be fine. The only things I can think of to look
out for are:
if you use distributed partitioned views you will have to change them
if you use indexed views, your related queries will need to have the
"noexpand" hint added.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||You can also try to do a detach and attach the database.
"xiaomei" wrote:

> Hi, There,
> I want move the database from 2000 Enterprise Edtion to 2000 Std, does Ms
> sql support that and any special way required?
>
> Thanks and regards
> Shermaine
|||Thanks too much, Paul, Lucas. Have a nice weekend!! .
"Paul Ibison" wrote:

> Shermaine,
> backup and restore should be fine. The only things I can think of to look
> out for are:
> if you use distributed partitioned views you will have to change them
> if you use indexed views, your related queries will need to have the
> "noexpand" hint added.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>

database file does not auto grow

Sql 2000 Enterprise SP3
Our current database is 25gb large but grows no longer automatic.
How this are possible?
Properties:
Automaticlly grow file
File growth by percenrtage 10 %
Maximum file size
Unrestricted file growthHi,
YOu have specified 10% auto growth and currently your database is 25 GB.
That means the autogrowth will be >2.5 GB. So just see if you have more than
2.5 GB free space
in hard disk.
Thanks
Hari
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>rowth wi|||Richard
It is possible that the data file has enough free space . How big is your
.BAK file? How long have you noticed that database does not grow?
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>|||49gb free
"Hari Prasad" wrote:
> Hi,
> YOu have specified 10% auto growth and currently your database is 25 GB.
> That means the autogrowth will be >2.5 GB. So just see if you have more than
> 2.5 GB free space
> in hard disk.
>
> Thanks
> Hari
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> > Sql 2000 Enterprise SP3
> > Our current database is 25gb large but grows no longer automatic.
> > How this are possible?
> >
> > Properties:
> > Automaticlly grow file
> > File growth by percenrtage 10 %
> > Maximum file size
> > Unrestricted file growth
> >
> >rowth wi
>
>|||Bak file = 20,3 gb
the problem is about 2 months old
"Uri Dimant" wrote:
> Richard
> It is possible that the data file has enough free space . How big is your
> ..BAK file? How long have you noticed that database does not grow?
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> > Sql 2000 Enterprise SP3
> > Our current database is 25gb large but grows no longer automatic.
> > How this are possible?
> >
> > Properties:
> > Automaticlly grow file
> > File growth by percenrtage 10 %
> > Maximum file size
> > Unrestricted file growth
> >
> >
>
>|||Richard
> Bak file = 20,3 gb
So , roughly you have 5GB free within data files
> the problem is about 2 months old
I don't think that's problem at all
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
> Bak file = 20,3 gb
> the problem is about 2 months old
> "Uri Dimant" wrote:
>> Richard
>> It is possible that the data file has enough free space . How big is your
>> ..BAK file? How long have you noticed that database does not grow?
>>
>>
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>> > Sql 2000 Enterprise SP3
>> > Our current database is 25gb large but grows no longer automatic.
>> > How this are possible?
>> >
>> > Properties:
>> > Automaticlly grow file
>> > File growth by percenrtage 10 %
>> > Maximum file size
>> > Unrestricted file growth
>> >
>> >
>>|||Properties
General tab
space available = 116mb
"Uri Dimant" wrote:
> Richard
> > Bak file = 20,3 gb
> So , roughly you have 5GB free within data files
> > the problem is about 2 months old
> I don't think that's problem at all
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
> > Bak file = 20,3 gb
> > the problem is about 2 months old
> >
> > "Uri Dimant" wrote:
> >
> >> Richard
> >>
> >> It is possible that the data file has enough free space . How big is your
> >> ..BAK file? How long have you noticed that database does not grow?
> >>
> >>
> >>
> >>
> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> >> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> >> > Sql 2000 Enterprise SP3
> >> > Our current database is 25gb large but grows no longer automatic.
> >> > How this are possible?
> >> >
> >> > Properties:
> >> > Automaticlly grow file
> >> > File growth by percenrtage 10 %
> >> > Maximum file size
> >> > Unrestricted file growth
> >> >
> >> >
> >>
> >>
> >>
>
>|||Run
DBCC UPDATEUSAGE (0)
sp_spaceused
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
> Properties
> General tab
> space available = 116mb
> "Uri Dimant" wrote:
>> Richard
>> > Bak file = 20,3 gb
>> So , roughly you have 5GB free within data files
>> > the problem is about 2 months old
>> I don't think that's problem at all
>>
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
>> > Bak file = 20,3 gb
>> > the problem is about 2 months old
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Richard
>> >>
>> >> It is possible that the data file has enough free space . How big is
>> >> your
>> >> ..BAK file? How long have you noticed that database does not grow?
>> >>
>> >>
>> >>
>> >>
>> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> >> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>> >> > Sql 2000 Enterprise SP3
>> >> > Our current database is 25gb large but grows no longer automatic.
>> >> > How this are possible?
>> >> >
>> >> > Properties:
>> >> > Automaticlly grow file
>> >> > File growth by percenrtage 10 %
>> >> > Maximum file size
>> >> > Unrestricted file growth
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||sp_spaceused
database_size 22256.56 mb unallocated space -2050.81 mb
reserved 22594752 kb data 17937184 kb index_size 2045344 kb unused 2612224 kb
"Uri Dimant" wrote:
> Run
> DBCC UPDATEUSAGE (0)
> sp_spaceused
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
> > Properties
> > General tab
> > space available = 116mb
> >
> > "Uri Dimant" wrote:
> >
> >> Richard
> >> > Bak file = 20,3 gb
> >>
> >> So , roughly you have 5GB free within data files
> >>
> >> > the problem is about 2 months old
> >>
> >> I don't think that's problem at all
> >>
> >>
> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> >> news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
> >> > Bak file = 20,3 gb
> >> > the problem is about 2 months old
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> >> Richard
> >> >>
> >> >> It is possible that the data file has enough free space . How big is
> >> >> your
> >> >> ..BAK file? How long have you noticed that database does not grow?
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> >> >> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> >> >> > Sql 2000 Enterprise SP3
> >> >> > Our current database is 25gb large but grows no longer automatic.
> >> >> > How this are possible?
> >> >> >
> >> >> > Properties:
> >> >> > Automaticlly grow file
> >> >> > File growth by percenrtage 10 %
> >> >> > Maximum file size
> >> >> > Unrestricted file growth
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||10% auto growth is not OK for larger databases. Increment size is 2.5GB in
that case so your disk system would have to write 2.5GB in 30 seconds on
disk. That's almost 100MB/second. Is your disk subsystem that fast? After 30
seconds clients get time-outs (by default) and file growth is canceled. You
can manualy expand file size to desired size or specify smaller fixed
increment size (256MB..)
Tom
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uiEfXEWCHHA.3540@.TK2MSFTNGP03.phx.gbl...
> Run
> DBCC UPDATEUSAGE (0)
> sp_spaceused
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
>> Properties
>> General tab
>> space available = 116mb
>> "Uri Dimant" wrote:
>> Richard
>> > Bak file = 20,3 gb
>> So , roughly you have 5GB free within data files
>> > the problem is about 2 months old
>> I don't think that's problem at all
>>
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
>> > Bak file = 20,3 gb
>> > the problem is about 2 months old
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Richard
>> >>
>> >> It is possible that the data file has enough free space . How big is
>> >> your
>> >> ..BAK file? How long have you noticed that database does not grow?
>> >>
>> >>
>> >>
>> >>
>> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> >> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>> >> > Sql 2000 Enterprise SP3
>> >> > Our current database is 25gb large but grows no longer automatic.
>> >> > How this are possible?
>> >> >
>> >> > Properties:
>> >> > Automaticlly grow file
>> >> > File growth by percenrtage 10 %
>> >> > Maximum file size
>> >> > Unrestricted file growth
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>|||Richard
http://www.sql-server-performance.com/database_settings.asp
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:506BA27E-4C9D-4D37-BD1E-7075074257DA@.microsoft.com...
> sp_spaceused
> database_size 22256.56 mb unallocated space -2050.81 mb
> reserved 22594752 kb data 17937184 kb index_size 2045344 kb unused 2612224
> kb
> "Uri Dimant" wrote:
>> Run
>> DBCC UPDATEUSAGE (0)
>> sp_spaceused
>>
>>
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
>> > Properties
>> > General tab
>> > space available = 116mb
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Richard
>> >> > Bak file = 20,3 gb
>> >>
>> >> So , roughly you have 5GB free within data files
>> >>
>> >> > the problem is about 2 months old
>> >>
>> >> I don't think that's problem at all
>> >>
>> >>
>> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> >> news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
>> >> > Bak file = 20,3 gb
>> >> > the problem is about 2 months old
>> >> >
>> >> > "Uri Dimant" wrote:
>> >> >
>> >> >> Richard
>> >> >>
>> >> >> It is possible that the data file has enough free space . How big
>> >> >> is
>> >> >> your
>> >> >> ..BAK file? How long have you noticed that database does not
>> >> >> grow?
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> >> >> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>> >> >> > Sql 2000 Enterprise SP3
>> >> >> > Our current database is 25gb large but grows no longer automatic.
>> >> >> > How this are possible?
>> >> >> >
>> >> >> > Properties:
>> >> >> > Automaticlly grow file
>> >> >> > File growth by percenrtage 10 %
>> >> >> > Maximum file size
>> >> >> > Unrestricted file growth
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

database file does not auto grow

Sql 2000 Enterprise SP3
Our current database is 25gb large but grows no longer automatic.
How this are possible?
Properties:
Automaticlly grow file
File growth by percenrtage 10 %
Maximum file size
Unrestricted file growthHi,
YOu have specified 10% auto growth and currently your database is 25 GB.
That means the autogrowth will be >2.5 GB. So just see if you have more than
2.5 GB free space
in hard disk.
Thanks
Hari
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>rowth wi|||Richard
It is possible that the data file has enough free space . How big is your
.BAK file? How long have you noticed that database does not grow?
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>|||49gb free
"Hari Prasad" wrote:

> Hi,
> YOu have specified 10% auto growth and currently your database is 25 GB.
> That means the autogrowth will be >2.5 GB. So just see if you have more th
an
> 2.5 GB free space
> in hard disk.
>
> Thanks
> Hari
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>
>|||Bak file = 20,3 gb
the problem is about 2 months old
"Uri Dimant" wrote:

> Richard
> It is possible that the data file has enough free space . How big is your
> ..BAK file? How long have you noticed that database does not grow?
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>
>|||Richard
> Bak file = 20,3 gb
So , roughly you have 5GB free within data files

> the problem is about 2 months old
I don't think that's problem at all
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...[vbcol=seagreen]
> Bak file = 20,3 gb
> the problem is about 2 months old
> "Uri Dimant" wrote:
>|||Properties
General tab
space available = 116mb
"Uri Dimant" wrote:

> Richard
> So , roughly you have 5GB free within data files
>
> I don't think that's problem at all
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
>
>|||Run
DBCC UPDATEUSAGE (0)
sp_spaceused
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...[vbcol=seagreen]
> Properties
> General tab
> space available = 116mb
> "Uri Dimant" wrote:
>|||sp_spaceused
database_size 22256.56 mb unallocated space -2050.81 mb
reserved 22594752 kb data 17937184 kb index_size 2045344 kb unused 2612224 k
b
"Uri Dimant" wrote:

> Run
> DBCC UPDATEUSAGE (0)
> sp_spaceused
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
>
>|||10% auto growth is not OK for larger databases. Increment size is 2.5GB in
that case so your disk system would have to write 2.5GB in 30 seconds on
disk. That's almost 100MB/second. Is your disk subsystem that fast? After 30
seconds clients get time-outs (by default) and file growth is canceled. You
can manualy expand file size to desired size or specify smaller fixed
increment size (256MB..)
Tom
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uiEfXEWCHHA.3540@.TK2MSFTNGP03.phx.gbl...
> Run
> DBCC UPDATEUSAGE (0)
> sp_spaceused
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
>

database file does not auto grow

Sql 2000 Enterprise SP3
Our current database is 25gb large but grows no longer automatic.
How this are possible?
Properties:
Automaticlly grow file
File growth by percenrtage 10 %
Maximum file size
Unrestricted file growth
Hi,
YOu have specified 10% auto growth and currently your database is 25 GB.
That means the autogrowth will be >2.5 GB. So just see if you have more than
2.5 GB free space
in hard disk.
Thanks
Hari
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>rowth wi
|||Richard
It is possible that the data file has enough free space . How big is your
..BAK file? How long have you noticed that database does not grow?
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
> Sql 2000 Enterprise SP3
> Our current database is 25gb large but grows no longer automatic.
> How this are possible?
> Properties:
> Automaticlly grow file
> File growth by percenrtage 10 %
> Maximum file size
> Unrestricted file growth
>
|||49gb free
"Hari Prasad" wrote:

> Hi,
> YOu have specified 10% auto growth and currently your database is 25 GB.
> That means the autogrowth will be >2.5 GB. So just see if you have more than
> 2.5 GB free space
> in hard disk.
>
> Thanks
> Hari
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>
>
|||Bak file = 20,3 gb
the problem is about 2 months old
"Uri Dimant" wrote:

> Richard
> It is possible that the data file has enough free space . How big is your
> ..BAK file? How long have you noticed that database does not grow?
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F97E1700-B6D7-476E-9D00-0B4E596A5BF8@.microsoft.com...
>
>
|||Richard
> Bak file = 20,3 gb
So , roughly you have 5GB free within data files

> the problem is about 2 months old
I don't think that's problem at all
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...[vbcol=seagreen]
> Bak file = 20,3 gb
> the problem is about 2 months old
> "Uri Dimant" wrote:
|||Properties
General tab
space available = 116mb
"Uri Dimant" wrote:

> Richard
> So , roughly you have 5GB free within data files
>
> I don't think that's problem at all
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:E6001F5E-CF5C-4E8F-B64D-4EABCB4E8C93@.microsoft.com...
>
>
|||Run
DBCC UPDATEUSAGE (0)
sp_spaceused
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...[vbcol=seagreen]
> Properties
> General tab
> space available = 116mb
> "Uri Dimant" wrote:
|||sp_spaceused
database_size 22256.56 mb unallocated space -2050.81 mb
reserved 22594752 kb data 17937184 kb index_size 2045344 kb unused 2612224 kb
"Uri Dimant" wrote:

> Run
> DBCC UPDATEUSAGE (0)
> sp_spaceused
>
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:B3B31B8F-6561-407E-9D84-DF75038E60DD@.microsoft.com...
>
>
|||Richard
http://www.sql-server-performance.com/database_settings.asp
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:506BA27E-4C9D-4D37-BD1E-7075074257DA@.microsoft.com...[vbcol=seagreen]
> sp_spaceused
> database_size 22256.56 mb unallocated space -2050.81 mb
> reserved 22594752 kb data 17937184 kb index_size 2045344 kb unused 2612224
> kb
> "Uri Dimant" wrote:
sql

database error -help

I'm using sqlserver 2000 and when i go to enterprise
manager and click on one of the database it is giving me
internet explorer script error. it is refering to
c:/programfiles/mssql2000/80/tools/bin/resources/1033/sqlmm
c.rll/tabs.html
Can anyone help please?Try switching from taskpad view to anything else, select
the database (should be no error), then go back to taskpad
view. Of the top of my head, this is the one issue I can
think of...
>--Original Message--
>I'm using sqlserver 2000 and when i go to enterprise
>manager and click on one of the database it is giving me
>internet explorer script error. it is refering to
>c:/programfiles/mssql2000/80/tools/bin/resources/1033/sqlm
m
>c.rll/tabs.html
>Can anyone help please?
>.
>

database disappearence

All of a sudden all the databases under the SQL Server Enterprise Manager have disappeared. Any idea why and how to get them back? I 'm on SQL 2000 with SP3Damn Miracle thing again....

Close and restart EM...What happens?|||That sure is a miracle brett :)|||I though miracles were supposed to be good things? Sounds more like a voodoo curse to me.

Try waving a dead chicken over it.

Database Diagrams from SQL Server

In your experiences, what is the best way to create Database Diagrams?
SQL Server Enterprise Manager Diagrams or Visio?
In SQL Server Enterprise Manager, when I create a "Diagram" and then try to
"Autosize Selected Tables" it leaves a lot of white space at the top which
results in the Table printing over one page. Is there any way to control
this? Does that have something to do with my printer set-up? Even if I
click and drag the table to the top of the page, it automatically slides it
down again creating that white space.
If I Reverse Engineer the Table into Visio, the column attributes are not
showing up.
I welcome your opinions and your help is GREATLY appreciated.
Thanks!
wnfisba
My best way to do this is to use Visio Enterprise Edition (with
reeingineering tool). YOu have a good chance to do your modifications
in here and deploy them right away in the server. Another tool which is
often mentioned is Erwin - a database modelling solution.
HTH, Jens Suessmeyer.
|||When attempting to Reverse Engineer into Visio, I am not seeing the column
attributes. The column names are coming
over, but not their attributes. Can I change that?
Please let me know.
Thanks!
"Jens" wrote:

> My best way to do this is to use Visio Enterprise Edition (with
> reeingineering tool). YOu have a good chance to do your modifications
> in here and deploy them right away in the server. Another tool which is
> often mentioned is Erwin - a database modelling solution.
> HTH, Jens Suessmeyer.
>
|||I also prefer Visio (or Erwin or ERstudio or pretty much
anything) over the Diagram tool in Enterprise Manager.
In terms of the columns in Visio, that's just a setting you
can change. In Visio, open the diagram, go to the menu and
select Database, then Options, then Document. A database
document window pops up. On the tables tab, you can select
what is displayed for the tables in the diagram (which types
of columns, if you want to display data types, etc.).
-Sue
On Thu, 19 Jan 2006 11:50:02 -0800, "wnfisba"
<wnfisba@.discussions.microsoft.com> wrote:

>In your experiences, what is the best way to create Database Diagrams?
>SQL Server Enterprise Manager Diagrams or Visio?
>In SQL Server Enterprise Manager, when I create a "Diagram" and then try to
>"Autosize Selected Tables" it leaves a lot of white space at the top which
>results in the Table printing over one page. Is there any way to control
>this? Does that have something to do with my printer set-up? Even if I
>click and drag the table to the top of the page, it automatically slides it
>down again creating that white space.
>If I Reverse Engineer the Table into Visio, the column attributes are not
>showing up.
>I welcome your opinions and your help is GREATLY appreciated.
>Thanks!
>wnfisba

Database Diagrams export

Hi, Can someone help me?
I need to create a tree structured diagram of our Server databases. I know how to create diagrams via the Enterprise manager, but I don't know how I can export them into some format, that I can further work with (doc., txt.,etc.). Is there some other tool, then the one in enterprise manager?
Thanks in advance.
Magdalena.That may be helpful:

Script SQL Server 2005 diagrams to a file

Database diagrams

Can a Database Diagram be imported or exported so that the schema can be
shown to someone that does not have Enterprise Manager installed on their
system?
If so what tools can do this?
No; you can do a screen capture or print to a PDF, perhaps.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Jim Abel" <JimAbel@.discussions.microsoft.com> wrote in message
news:65C71846-71F2-4875-B0C8-79C18104F5CF@.microsoft.com...
> Can a Database Diagram be imported or exported so that the schema can be
> shown to someone that does not have Enterprise Manager installed on their
> system?
> If so what tools can do this?

Database diagrams

Can a Database Diagram be imported or exported so that the schema can be
shown to someone that does not have Enterprise Manager installed on their
system?
If so what tools can do this?No; you can do a screen capture or print to a PDF, perhaps.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Jim Abel" <JimAbel@.discussions.microsoft.com> wrote in message
news:65C71846-71F2-4875-B0C8-79C18104F5CF@.microsoft.com...
> Can a Database Diagram be imported or exported so that the schema can be
> shown to someone that does not have Enterprise Manager installed on their
> system?
> If so what tools can do this?

Database Diagrams

I have a question concerning the diagramming tool in SQL
Server 2000. On the development server the keys show up
in the table view of the Enterprise Manager and the
diagramming tool works as expected. However, when we
imported the database into production, the keys did not
come forward so the diagramming tool cannot diagram
relationships. The interesting thing is that the
application works as expected, except the keys dont show
up in the table view.
Question...how is this possible? How do I add the keys
to the design without disrupting the application?
ThanxYou are correct in the assumption that the application works due to the
error checking.
I'm working wiht Mike on this problem and somewhere along the line, all of
the keys got dropped in the production database. We want to recreate them
in the development database and then run the scripts against the production
database to create the keys and the relationships that are required. Is
there any way to automatically compare two versions of the database and
generate a batch of the the ALTER TABLE commands? Or am I looking at
writing each statement inividually?
Thanks
Dave
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:uGKT3TRVDHA.2192@.TK2MSFTNGP10.phx.gbl...
> Check if the FKs are in place. Use sp_help and sp_foreignkeys system SPs
to
> check if FKs are present. You can add them, if they are not in place,
using
> the ALTER TABLE command. If the application respects them, if it has input
> validation & error handling, you should have no problem.
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "Mike" <Mike149@.yahoo.com> wrote in message
> news:312f01c35514$024662e0$a001280a@.phx.gbl...
> > I have a question concerning the diagramming tool in SQL
> > Server 2000. On the development server the keys show up
> > in the table view of the Enterprise Manager and the
> > diagramming tool works as expected. However, when we
> > imported the database into production, the keys did not
> > come forward so the diagramming tool cannot diagram
> > relationships. The interesting thing is that the
> > application works as expected, except the keys dont show
> > up in the table view.
> >
> > Question...how is this possible? How do I add the keys
> > to the design without disrupting the application?
> >
> > Thanx
>

Database diagrams

Can a Database Diagram be imported or exported so that the schema can be
shown to someone that does not have Enterprise Manager installed on their
system?
If so what tools can do this?No; you can do a screen capture or print to a PDF, perhaps.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Jim Abel" <JimAbel@.discussions.microsoft.com> wrote in message
news:65C71846-71F2-4875-B0C8-79C18104F5CF@.microsoft.com...
> Can a Database Diagram be imported or exported so that the schema can be
> shown to someone that does not have Enterprise Manager installed on their
> system?
> If so what tools can do this?

Database diagram support objects cannot be installed...

I can't make a diagram on our server(Win2003 x64,SQL 2005 Enterprise x64 sp2 3054).

I have tried to login as an admin and create a new db, but get the same message -

'Database diagram support objects cannot be installed because this database does not have a valid owner. To..'

Also tried to make a diagram from the ReportServer db.

Any suggestions?

Two things to check.

1. please make sure that db has a owner (as the error suggests).

2. please check your compatibility level.

|||

Thanks Meher for your reply.

1. Both of the databases I tried has a owner.

2. I'm pretty sure the compatibility level is 90 (SQL 2005) since one is created during installation(ReportServer) and the other is created as a new db in SQL Management Studio. (To be sure I will check next week)

Any other suggestions?

|||

Are you still getting the error message?. As you have mentioned check the compatibility level once again and if you are still getting the message we can look a bit further.

|||

The compatibility level is 90(SQL Server 2005).

|||

what role do you belong to?. pls check

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/6fdecefb-7bd3-4203-a58c-36d46ee628bf.htm

|||db_owner |||

Hi olof,

can you please go through the steps outlined in section 4.8.1 in http://support.microsoft.com/?id=910228

As per the section in the article, looks like you might have to install the diagram support.

To create database diagrams, change the database compatibility level to 2005, install database diagram support, and then return the database to the desired database compatibility level.

MVPs, please correct me if I am missing something.

Thanks

Meher

|||

one other thing I forgot to mention is that the installation of support objects can fail if the database

has been attached or restored from another instance of SQL Server. In such a case there is a

possibility that the database owner name stored in the database may not be a valid logon for the

instance of the SQL Server on to which the database is restored to (or attached to).

I would suggest if thats the case then you can use the Alter statement to change the owner to a valid logon.

ALTER AUTHORIZATION ON DATABASE::your dbname TO yourdesiredlogin

(please see BOL for more details on ALTER AUTHORIZATION).

I would suggest doing through T-SQL than UI and see if it solves your issue.

Thanks

Meher

Database data file does not auto-grow

Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>

Database data file does not auto-grow

Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
Ivan
Ivan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||dbcc updateusage?
Cheers,
"Ivan" wrote:

> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>

Database data file does not auto-grow

Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:

> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
>
>