缩小dbs /文件
问题描述:
大家好,
萎缩时哪一个好用?
DBCC SHRINKFILE()
DBCC SHRINKDATABASE()
我知道收缩很糟糕, 但是,如果我可能必须使用哪一个是好的,为什么?
谢谢,
Sam
Hi All,
Which one is good to use while shrinking ?
DBCC SHRINKFILE()
DBCC SHRINKDATABASE()
I know shrinking is bad, however if I may have to use which one is good and WHY?
Thanks,
Sam
答
两者都做同样的事;仅在一个数据库文件上收缩文件,在所有文件上收缩数据库。
Both do the same; shrink file on just one database file, shrink database on all files.