Shrinking databases and database files in SQL Server DBA:
The size of database is reduced by collectively shrinking the database files,releasing unused space.
TO shrink individual database files.
We can shrink tempdb. But shrinking files regularly is not a recommended practice, because these files may probably grow again. Also shrink operations causes’ data fragmentation.
We have some limitations on shrinking tempdb:
Shrink operations do not shrink the version store or internal objects.
In some cases the DBA might need to restart the server in a single user mode to allow shrinking of the tempdb.
0 comments:
Post a Comment