WITH INIT, TO

torsten.strausstorsten.strauss Posts: 271 Silver 3
edited January 7, 2018 2:46PM in SQL Prompt
Hi Redgate Team,

After formatting the following code the INIT is sent to the end of the next line, which is wrong.
Additionally you can see that an unneeded space is added after TO.
:SETVAR BackupPath "C:\Program Files\Microsoft SQL Server\MSSQL14.MYSQLSERVER2017\MSSQL\Backup\"
-- Full and transactional backup to release space in the transaction log
BACKUP DATABASE BulkLogged TO  DISK = '$(BackupPath)\BulkLogged.bak' WITH
																		 INIT
BACKUP LOG BulkLogged TO  DISK = '$(BackupPath)\BulkLogged.trn' WITH INIT;
GO

Thanks for looking into this!

Version 9.0.5.3501

Style attached ...

Torsten

Answers

Sign In or Register to comment.