Viewing 15 posts - 76 through 90 (of 821 total)
The correct answer is: "The command seems to pause and hang, and the add file operation will run when the backup is complete."
From BOL: https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017
Interoperability
SQL Server uses an online...
July 18, 2019 at 8:03 am
Well done, "WAITFOR DELAY '00:00:05' " makes the difference.
June 17, 2019 at 9:18 am
My results:
Processed 5128 pages for database 'test', file 'test' on file 1.
100 percent processed.
Processed 3 pages for database 'test', file 'test_log' on file 1.
BACKUP DATABASE WITH DIFFERENTIAL successfully processed 5131...
June 17, 2019 at 7:45 am
Maybe R language is case sensitive? So, Sys.time() is the correct answer, but it's not in the list.
May 8, 2019 at 7:42 am
DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0)Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your...
February 28, 2019 at 2:27 am
February 26, 2019 at 2:02 am
December 27, 2018 at 9:28 am
December 19, 2018 at 2:17 am
December 6, 2018 at 6:53 am
I believe you meant "not" rather than "now".
However, your first example is also...
November 14, 2018 at 6:43 am
forgot that the results of this datetime function is...
November 9, 2018 at 1:54 am
November 7, 2018 at 4:32 am
Viewing 15 posts - 76 through 90 (of 821 total)