473,241 Members | 1,465 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

shrink file tool from EM took all the empty space allocated to data file

SP
I've production sql server 7 sp3 on windows NT. I had a 8GB data file of
which 5GB were used and 3GB were unused. I wanted to take back the unused
3GB.
So I did the following with EM GUI:
1. I tried to "truncate fre space from end of the file". Didn't truncate
the file. I believe there was no empty space at the end of the file.
2. Next I chose the option to "shrink file to 5GB". And to my horror the
data file instead of taking just 5GB took the empty spaces also and the size
of the used data file went to 8GB.
Any idea what's going on?
TIA,
SP
Jul 20 '05 #1
2 3027
Do you have text and image data? If so, it might be:
http://support.microsoft.com/default...27&Product=sql

I suggest you search KB for SQL Server for the word "shrink", I got hit on
number of KB articles.

--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=d...blic.sqlserver
"SP" <sd*********************@yahoo.com> wrote in message
news:B5******************@sea-read.news.verio.net...
I've production sql server 7 sp3 on windows NT. I had a 8GB data file of
which 5GB were used and 3GB were unused. I wanted to take back the unused
3GB.
So I did the following with EM GUI:
1. I tried to "truncate fre space from end of the file". Didn't truncate
the file. I believe there was no empty space at the end of the file.
2. Next I chose the option to "shrink file to 5GB". And to my horror the
data file instead of taking just 5GB took the empty spaces also and the size of the used data file went to 8GB.
Any idea what's going on?
TIA,
SP

Jul 20 '05 #2
SP
Thanks Tibor. Though we keep just the image file name we have text columns,
but not many. Looks like i should test with sp4. Thanks a lot.
Sp
"Tibor Karaszi" <ti****************************************@corner stone.se>
wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl...
Do you have text and image data? If so, it might be:
http://support.microsoft.com/default...27&Product=sql

I suggest you search KB for SQL Server for the word "shrink", I got hit on
number of KB articles.

--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=d...blic.sqlserver

"SP" <sd*********************@yahoo.com> wrote in message
news:B5******************@sea-read.news.verio.net...
I've production sql server 7 sp3 on windows NT. I had a 8GB data file of which 5GB were used and 3GB were unused. I wanted to take back the unused 3GB.
So I did the following with EM GUI:
1. I tried to "truncate fre space from end of the file". Didn't truncate the file. I believe there was no empty space at the end of the file.
2. Next I chose the option to "shrink file to 5GB". And to my horror the data file instead of taking just 5GB took the empty spaces also and the

size
of the used data file went to 8GB.
Any idea what's going on?
TIA,
SP


Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: R Camarda | last post by:
Help, I have a database that has a data file of 2GB and a log file of 31GB. In enterprise manager, when I choose shrink it says there is 30GB of unused space. When I shrink the database, it does...
1
by: Fibre Optic | last post by:
Hello, I try to shrink DB, in "Shrink action" I mark "Truncate free space from the end of file". After press "OK" button I see such a message: "Error 8985: Could not locate file...
5
by: BashiraInTrouble | last post by:
Hi Friends, I have tried almost everything but I cant seem to shrink the transaction log. Executing DBCC SQLPERF(LOGSPACE) gives me this info: Database Log Size (MB) Log Space Used (%) ...
17
by: Arnold | last post by:
Is using fseek and ftell a reliable method of getting the file size on a binary file? I thought I remember reading somewhere it wasn't... If not what would be the "right" and portable method to...
32
by: Clunixchit | last post by:
How can i read lines of a file and place each line read in an array? for exemple; array=line1 array=line2 ...
26
by: Michel Rouzic | last post by:
I have a binary file used to store the values of variables in order to use them again. I easily know whether the file exists or not, but the problem is, in case the program has been earlier...
13
by: Matik | last post by:
Hello everybody, First: SQL Server 2000 sp3a, HP cluster server, MS 2003 server, database recovery model simple Torn page detection: When I have this option turned on, processes conected with...
3
by: Galka | last post by:
Hello Environment: Windows XP, MS Access 2003. I'd like - in a report - to save space , when there is no company data. When there is, I print out company name, address, telephone number and...
6
by: Major Drake | last post by:
Windows 2003 64 bit sp2 + SQL Server std 32 bit sp2 compability mode 90, recovery model simple. I have about 40 Gb database where is about 98% free space (I deleted data from tables). dbcc...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.