Skip to content

Instantly share code, notes, and snippets.

@maftieu

maftieu/shrink.sql

Created September 17, 2015 10:53
Show Gist options
  • Save maftieu/6a8eb1f4902fa1f18c95 to your computer and use it in GitHub Desktop.
Save maftieu/6a8eb1f4902fa1f18c95 to your computer and use it in GitHub Desktop.
Download ZIP
Shrink database
Raw
shrink.sql
-- réduire les LOGS
BACKUP LOG [Concours] TO DISK = N'E:\Backup\Concours-logs.bak'
USE [Concours]
ALTER DATABASE [Concours] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(Concours_Log, 1)
ALTER DATABASE [Concours] SET RECOVERY FULL WITH NO_WAIT
-- réduire le fichier de DATA
--BACKUP DATABASE [Concours] TO DISK = N'E:\Backup\Concours.bak' WITH NOFORMAT, NOINIT, NAME = N'Concours-Complète Base de données Sauvegarde', SKIP, NOREWIND, NOUNLOAD, STATS = 10
--DBCC SHRINKDATABASE(N'Concours' )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment