Jack_Crouch
Well Known Member
OK... I am an idiot here on SQL Server.
Trying to get the hang of it. Starting to like what I can do in Enterprise
Manager.
But I have what I thought was a simple thing (probably is)...
We copied PY7333 Central objects over to PD7333 using the UBE for this.
F980011 and F980021 are the xref files and take up 5.5gb (all the other
files combined take up 2.5gb). I don't want any data in these files.
So I ran a TRUNCATE TABLE command on both of them. Seemed to work like a
champ.
However the
PD7333data.mdf still remains 8.5gb. So I attempted to shrink the database
(from Enterprise Manager). Well, this file grew to 21.5gb (and the log
went to 3.3gb).
So, I'll bite. Is there an Enlarge command that actually makes the file
smaller? What am I doing wrong?
AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
Trying to get the hang of it. Starting to like what I can do in Enterprise
Manager.
But I have what I thought was a simple thing (probably is)...
We copied PY7333 Central objects over to PD7333 using the UBE for this.
F980011 and F980021 are the xref files and take up 5.5gb (all the other
files combined take up 2.5gb). I don't want any data in these files.
So I ran a TRUNCATE TABLE command on both of them. Seemed to work like a
champ.
However the
PD7333data.mdf still remains 8.5gb. So I attempted to shrink the database
(from Enterprise Manager). Well, this file grew to 21.5gb (and the log
went to 3.3gb).
So, I'll bite. Is there an Enlarge command that actually makes the file
smaller? What am I doing wrong?
AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO