HELP URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider) 
Author Message
 HELP URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)

Hi,
It didnt'work...
Really I don't understand... the size shown in MMC is for example 91 Mo for
a table. But with another software it's real size is 7 Mo.
Therefore when I do my backups it takes 91 Mo which uses a lot of disk
space.
Doing an export of the table reduces it to its good size but I can't do this
because my website is always live.
If you have a clue I'd really like you send it to me.

Thx.
Laurent.


Quote:
> Do you mean where the MMC shows a hugh data file, you
> restore and then you have a large log file?
> If you have run a DBCC SHRINKFILE and BACKUP LOG and the
> log did not reduce in size, there is an open transaction
> at the end of the active portion of the virtual log file.
> Most of the time this is not a problem unless you need log
> space.
> If this is what you are talking about, there is a way
> around it and I can email it to you.

________________________

Hi,
I use SQL server 7sp3 + all patches on NT4 server with all patches too (and
MMC 1.2).
I found a big bug : tables in MMC appear much bigger than they are (ex : 91
Mo in MMC and 7 Mo with SQL insider).
I found a way to shrint it back making a backup of table and reassingning it
with primary key and so on. It's not easy. Itried to shrink tables but
nothing works. In result another pb appears with backups : they actually do
the size MMC shows them.

Can someone help on this pb ?

thanx



Sat, 28 Feb 2004 20:05:50 GMT
 HELP URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)

What "other software" are you talking about?

From what you described, your database is really 91 Meg since your backup is
of that size.  Keep in mind that backups include indexes which can add up to
a good amount of disk space.

--
Ross Nornes
DBA Services Manager
James Tower
http://www.JamesTower.Com


Quote:

> Hi,
> It didnt'work...
> Really I don't understand... the size shown in MMC is for example 91 Mo
for
> a table. But with another software it's real size is 7 Mo.
> Therefore when I do my backups it takes 91 Mo which uses a lot of disk
> space.
> Doing an export of the table reduces it to its good size but I can't do
this
> because my website is always live.
> If you have a clue I'd really like you send it to me.

> Thx.
> Laurent.



> > Do you mean where the MMC shows a hugh data file, you
> > restore and then you have a large log file?
> > If you have run a DBCC SHRINKFILE and BACKUP LOG and the
> > log did not reduce in size, there is an open transaction
> > at the end of the active portion of the virtual log file.
> > Most of the time this is not a problem unless you need log
> > space.
> > If this is what you are talking about, there is a way
> > around it and I can email it to you.

> ________________________

> Hi,
> I use SQL server 7sp3 + all patches on NT4 server with all patches too
(and
> MMC 1.2).
> I found a big bug : tables in MMC appear much bigger than they are (ex :
91
> Mo in MMC and 7 Mo with SQL insider).
> I found a way to shrint it back making a backup of table and reassingning
it
> with primary key and so on. It's not easy. Itried to shrink tables but
> nothing works. In result another pb appears with backups : they actually
do
> the size MMC shows them.

> Can someone help on this pb ?

> thanx



Sat, 28 Feb 2004 21:00:06 GMT
 HELP URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)
The software used is SQL INSIDER.
Well I'd like to know if I can get rid of these indexes ?
I managed getting my real table size by exporting the table, but I have to
rebuild primary key and default values. As my database is for a website I
can't have a break since doing this operation will also need me to rebuild
catalogs.

Plz help me out of this...

Laurent


Quote:
> What "other software" are you talking about?

> From what you described, your database is really 91 Meg since your backup
is
> of that size.  Keep in mind that backups include indexes which can add up
to
> a good amount of disk space.

> --
> Ross Nornes
> DBA Services Manager
> James Tower
> http://www.JamesTower.Com



> > Hi,
> > It didnt'work...
> > Really I don't understand... the size shown in MMC is for example 91 Mo
> for
> > a table. But with another software it's real size is 7 Mo.
> > Therefore when I do my backups it takes 91 Mo which uses a lot of disk
> > space.
> > Doing an export of the table reduces it to its good size but I can't do
> this
> > because my website is always live.
> > If you have a clue I'd really like you send it to me.

> > Thx.
> > Laurent.



> > > Do you mean where the MMC shows a hugh data file, you
> > > restore and then you have a large log file?
> > > If you have run a DBCC SHRINKFILE and BACKUP LOG and the
> > > log did not reduce in size, there is an open transaction
> > > at the end of the active portion of the virtual log file.
> > > Most of the time this is not a problem unless you need log
> > > space.
> > > If this is what you are talking about, there is a way
> > > around it and I can email it to you.

> > ________________________

> > Hi,
> > I use SQL server 7sp3 + all patches on NT4 server with all patches too
> (and
> > MMC 1.2).
> > I found a big bug : tables in MMC appear much bigger than they are (ex :
> 91
> > Mo in MMC and 7 Mo with SQL insider).
> > I found a way to shrint it back making a backup of table and
reassingning
> it
> > with primary key and so on. It's not easy. Itried to shrink tables but
> > nothing works. In result another pb appears with backups : they actually
> do
> > the size MMC shows them.

> > Can someone help on this pb ?

> > thanx



Sat, 28 Feb 2004 21:11:15 GMT
 HELP URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)
STILL NEEDING HELP


Quote:

> Hi,
> It didnt'work...
> Really I don't understand... the size shown in MMC is for example 91 Mo
for
> a table. But with another software it's real size is 7 Mo.
> Therefore when I do my backups it takes 91 Mo which uses a lot of disk
> space.
> Doing an export of the table reduces it to its good size but I can't do
this
> because my website is always live.
> If you have a clue I'd really like you send it to me.

> Thx.
> Laurent.



> > Do you mean where the MMC shows a hugh data file, you
> > restore and then you have a large log file?
> > If you have run a DBCC SHRINKFILE and BACKUP LOG and the
> > log did not reduce in size, there is an open transaction
> > at the end of the active portion of the virtual log file.
> > Most of the time this is not a problem unless you need log
> > space.
> > If this is what you are talking about, there is a way
> > around it and I can email it to you.

> ________________________

> Hi,
> I use SQL server 7sp3 + all patches on NT4 server with all patches too
(and
> MMC 1.2).
> I found a big bug : tables in MMC appear much bigger than they are (ex :
91
> Mo in MMC and 7 Mo with SQL insider).
> I found a way to shrint it back making a backup of table and reassingning
it
> with primary key and so on. It's not easy. Itried to shrink tables but
> nothing works. In result another pb appears with backups : they actually
do
> the size MMC shows them.

> Can someone help on this pb ?

> thanx



Sun, 29 Feb 2004 20:58:20 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)

2. URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)

3. Database size bigger than device size???

4. Database File Size - big size little info

5. SQL SERVER Table size and Index size query

6. Table Size - Urgent Help would be much appreicated !!

7. A script to recreate all tables with the *REAL* size used

8. How to clculate table REAL size.

9. Optimum Configuration for Page Size, NTFS Allocation Unit size and RAID Stripe size

10. Table Size too big??

11. Table size too big

12. Table size it too big


 
Powered by phpBB® Forum Software