am I using SHRINKFILE correctly?

I created some huge tables over the weekend for testing and I have since
dropped them since I don't need them however my database is still over 3
gig. (pre testing size was a few hundred meg)
I'm doing
DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
DBCC SHRINKFILE(mydatabase_v1_Log,1)
and it seems to be working but the file size of the mdf file remains over 3
gig.
What am I missing here ?
Thanks alot.
Hi
It seems that there is still data in one of the later extents and
TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
specifying a target size instead.
John
"D" wrote:

> I created some huge tables over the weekend for testing and I have since
> dropped them since I don't need them however my database is still over 3
> gig. (pre testing size was a few hundred meg)
> I'm doing
> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
> DBCC SHRINKFILE(mydatabase_v1_Log,1)
> and it seems to be working but the file size of the mdf file remains over 3
> gig.
> What am I missing here ?
> Thanks alot.
>
>
|||That did it. Cool ! Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:085AADB1-D52A-488D-BE04-E5976C34D4DA@.microsoft.com...[vbcol=seagreen]
> Hi
> It seems that there is still data in one of the later extents and
> TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
> specifying a target size instead.
> John
> "D" wrote:

am I using SHRINKFILE correctly?

I created some huge tables over the weekend for testing and I have since
dropped them since I don't need them however my database is still over 3
gig. (pre testing size was a few hundred meg)
I'm doing
DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
DBCC SHRINKFILE(mydatabase_v1_Log,1)
and it seems to be working but the file size of the mdf file remains over 3
gig.
What am I missing here ?
Thanks alot.Hi
It seems that there is still data in one of the later extents and
TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
specifying a target size instead.
John
"D" wrote:

> I created some huge tables over the weekend for testing and I have since
> dropped them since I don't need them however my database is still over 3
> gig. (pre testing size was a few hundred meg)
> I'm doing
> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
> DBCC SHRINKFILE(mydatabase_v1_Log,1)
> and it seems to be working but the file size of the mdf file remains over
3
> gig.
> What am I missing here ?
> Thanks alot.
>
>|||That did it. Cool ! Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:085AADB1-D52A-488D-BE04-E5976C34D4DA@.microsoft.com...[vbcol=seagreen]
> Hi
> It seems that there is still data in one of the later extents and
> TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
> specifying a target size instead.
> John
> "D" wrote:
>

am I using SHRINKFILE correctly?

I created some huge tables over the weekend for testing and I have since
dropped them since I don't need them however my database is still over 3
gig. (pre testing size was a few hundred meg)
I'm doing
DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
DBCC SHRINKFILE(mydatabase_v1_Log,1)
and it seems to be working but the file size of the mdf file remains over 3
gig.
What am I missing here ?
Thanks alot.Hi
It seems that there is still data in one of the later extents and
TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
specifying a target size instead.
John
"D" wrote:
> I created some huge tables over the weekend for testing and I have since
> dropped them since I don't need them however my database is still over 3
> gig. (pre testing size was a few hundred meg)
> I'm doing
> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
> DBCC SHRINKFILE(mydatabase_v1_Log,1)
> and it seems to be working but the file size of the mdf file remains over 3
> gig.
> What am I missing here ?
> Thanks alot.
>
>|||That did it. Cool ! Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:085AADB1-D52A-488D-BE04-E5976C34D4DA@.microsoft.com...
> Hi
> It seems that there is still data in one of the later extents and
> TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
> specifying a target size instead.
> John
> "D" wrote:
>> I created some huge tables over the weekend for testing and I have since
>> dropped them since I don't need them however my database is still over 3
>> gig. (pre testing size was a few hundred meg)
>> I'm doing
>> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
>> DBCC SHRINKFILE(mydatabase_v1_Log,1)
>> and it seems to be working but the file size of the mdf file remains over
>> 3
>> gig.
>> What am I missing here ?
>> Thanks alot.
>>
>>

Always Fit-To-Page

All of the reports we have deployed (over 100) are wider than a standard letter sized page. In order to print them correctly, the Fit-To-Page option must be selected in the print dialog.

We desperately need a way to make this automatic. I know our users have killed a forest with the paper printed when they forget to select the option. If anyone knows of a way to make the setting of print options like Fit-To-Page automatic or programmatic please respond!

Thanks!

Mark

Go to Control Panel and go to properties of the printer and click Printing Preferences. For Paper Output, select Letter and click OK. Just try and let me know.

Shyam

|||

That might work but would not be a solution because it would effect every document printed off that workstation, not just the reports. We need a way to change the print properties for just the reports.

Thanks!

Mark.