Skip to Content
0
Former Member
Jan 22, 2011 at 07:20 AM

data files get smaller

20 Views

hi,

few days ago I noticed that data files (mdf, ndf - i am not talking about log file) sometimes get s small. auto shrink is turned off.

I checked it in dbacockpit->space->history->database size history.

is it OK? why it happens so? as I know without shrinking files should not get small (even if delete much data from data base).

we are doing full backup every night.

(OS - Win2003R2, DB - MSSQL2005 SP2, SAP - ERP6)

thanks in advance

Edited by: pharvana on Jan 22, 2011 8:22 AM