From the lazy log blog: CREATE TABLE test1 ( myvarchar varchar(5000)) GO INSERT INTO test1 VALUES( replicate(‘*’,5000)) GO 5000 DELETE FROM test1 At first, I did not understand but it works because the primary key constraint is missing :-) BACKUP LOG [LLTTest] TO DISK = N’C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\LLTTest.bak’ WITH NOFORMAT, NOINIT, NAME = N’LLTTest-Transaction Log Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10 What is the purpose of NOREWIND, NOUNLOAD when creating a disk file? What is the purpose of NOINIT/SKIP: "If the volume contains a valid media header, appends the backup set, preserving all existing backup sets."
I can't tell if this is a joke or not, because I was joking around in the video about how I couldn't answer random questions on UA-cam with any speed or accuracy :) The backup options are explained here: docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql It gives more details on all of those items if you have a question. (I can't tell if you're sharing or asking.)
Oh, sure! That would be a fun episode to talk through some of the cryptic backup terminology. I'll put that on my list. Thanks, I totally didn't get it. Probably because I was doing two things at once.
Thanks for the clear and nice explanation!
Thank you for this video! I'm experiencing a similar issue and this gave me a lot of information about what I can look into! :-)
From the lazy log blog:
CREATE TABLE test1 ( myvarchar varchar(5000))
GO
INSERT INTO test1 VALUES( replicate(‘*’,5000))
GO 5000
DELETE FROM test1
At first, I did not understand but it works because the primary key constraint is missing :-)
BACKUP LOG [LLTTest] TO DISK = N’C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\LLTTest.bak’ WITH NOFORMAT, NOINIT, NAME = N’LLTTest-Transaction Log Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10
What is the purpose of NOREWIND, NOUNLOAD when creating a disk file?
What is the purpose of NOINIT/SKIP: "If the volume contains a valid media header, appends the backup set, preserving all existing backup sets."
I can't tell if this is a joke or not, because I was joking around in the video about how I couldn't answer random questions on UA-cam with any speed or accuracy :)
The backup options are explained here: docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql
It gives more details on all of those items if you have a question. (I can't tell if you're sharing or asking.)
Thanks. I did not expect an answer but was just asking a “Dear SQL DBA” Question
Oh, sure! That would be a fun episode to talk through some of the cryptic backup terminology. I'll put that on my list.
Thanks, I totally didn't get it. Probably because I was doing two things at once.