How to shrink database size
As time goes by, the disk space requirements for your database may fluctuate greatly. You can set SQL Server to automatically expand a database when it requires more space; and you can also set it to "shrink" when it can reclaim allocated but unused space. Sometimes it makes sense to enable autogrow and autoshrink events, and sometimes it doesn't.
To reduce the database size on the file system just use following T-SQL:
BACKUP LOG tempdb with NO_LOG
dbcc shrinkdatabase(tempdb ,TRUNCATEONLY)
To reduce the database size on the file system just use following T-SQL:
BACKUP LOG tempdb with NO_LOG
dbcc shrinkdatabase(tempdb ,TRUNCATEONLY)
Comments
Write the first comment
Leave a trace
Post being viewed right now
