SQL Backup Shrink - Resolve Storage Issue

Опубликовано: 03 Июль 2026
на канале: Geo Magazine

100

in this video, name of the database is GISv12_Fiber

-- Step1: FULL BACKUP

BACKUP DATABASE [GISv12_Fiber]
TO DISK = N'M:\APPSQLP02\GISv12_Fiber_full20240514.bak' WITH NOFORMAT, NOINIT,
NAME = N'GISv12_Fiber-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO

-- Step2: TRANSACTION LOG BACKUP
BACKUP LOG [GISv12_Fiber]
TO DISK = N'M:\APPSQLP02\GISv12_Fiber_TRN_20240515_1.TRN' WITH NOFORMAT, NOINIT,
NAME = N'GISv12_Fiber-TRN Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
-- Step3: SHRINK LOG FILE [database right click - Tasks - Shrink - File - select Log]

Regards
Khalid Mahmood
GIS Manager
[email protected]