January 4, 2008 at 12:55 am
I have shortage of space. and my disk is going to full.
On db server total 320 small database are there.
Right now I am shrinking my all databases.
Before and after shrinking database is there any procedure/command.
Is it necessary to take full back up after shrinking.
Can any one suggest me..
Regards
Majid Jafar
January 4, 2008 at 1:56 am
You should rebuild all your indexes after shrinking a database, as a shrink causes very high fragmentation. This rebuild will probably cause the databases to grow again.
The thing is, databases need some free space to work. Shrinking may solve the interim problem or short of space. For the long term, you should look at moving some of the files to a different drive or adding space
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply