I have a database that I have backed-up and shrunk to try
and get it as small as possible. I was expecting to get
the size down under 10M. I have deleted most of the data
in the tables and as small as it will get is 38M. I
repeated the back-up and shrinking multiple times. Any
suggestions would be greatly appreciated.
Thanks,
Bill
Backups will not shrink your database. What other methods are you trying to
shrink the database? Norrmally you would use DBCC SHRINKFILE. Depending on
how your tables are architechted, 38 MB may be as small as it will go.
Jim
"bill" <anonymous@.discussions.microsoft.com> wrote in message
news:2dac01c4287f$b34dbb30$a001280a@.phx.gbl...
> I have a database that I have backed-up and shrunk to try
> and get it as small as possible. I was expecting to get
> the size down under 10M. I have deleted most of the data
> in the tables and as small as it will get is 38M. I
> repeated the back-up and shrinking multiple times. Any
> suggestions would be greatly appreciated.
> Thanks,
> Bill
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment