skip to content

[[programming:mssql:shrinkdatabase]]

wiki.borovicka.name

Trace: • shrinkdatabase

Navigation

Programming

C / C++
Python
C#
Scala
PowerShell
HTML, CSS, JavaScript
MSSQL
MATLAB
MarkTime
Latex
Other tricks
Utilities

School

Rozvrhy
FIT
FBMI
FEL

Links

Computational Intelligence Group
Data Science Laboratory at FIT

Other

playground
syntax

Shrink DataBase

it shrinks database

Code:

USE master
BACKUP LOG dbToShrink WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE  (dbToShrink)

programming/mssql/shrinkdatabase.txt · Last modified: 2018-06-21 19:48 (external edit)

CC Attribution-Noncommercial-Share Alike 4.0 International