Shrink Sql Server Log files on Production Databases

NUL是虛擬的空設備，寫入到NUL設備的資料將被丟棄。這是在DOS 作業系統(Disk Operating System)時就已經有的指令，在Windows 作業系統同樣可以使用。 用於 ...

The trick here is to take backup on NUL device. It's not a typo and there is no missing L in NUL. It is called as “NULL Device”.

What I Do In order to manage the transaction log size I run a log backup every 15 minutes to backup the log file to NUL as below. BACKUP LOG [ ...

有時將DB的復原模式轉成完整模式時，需要做一次完整的備份。 所以一開始只想讓它切過去而已，不想真的備份檔案出來， 就可以使用TO Disk = 'nul' ，

在BACKUP 陳述式內指定磁碟裝置之前，該裝置不需要存在。 如果實體裝置存在，且BACKUP 陳述式並未指定INIT 選項，就會將備份附加至裝置中。 NUL 裝置將捨棄傳送到此檔案的所 ... 選取產品 · SQL Server

NUL is basically a location you can send a backup to. In fact, one of the awesome bonuses of this location is that your backup will take up exactly 0 bytes of ...

You can use this command: BACKUP Log sandbox2 TO DISK = N'nul'. This will run a backup, and discard all of the backup data.

To recover the disk space, shrink the log file. You'll see disk use % drop. Set recovery to full, then take a full backup. This begins the log chain.

BACKUP DATABASE Test TO DISK = 'NUL'. Then as far as SQL Server is concerned you took a backup, but the backup file is never actually created.

Backup Log ... to disk = 'Nul' is a really nasty way to break the log chain and not have it easily noticeable.