T-SQL script to Backup database SQL Server with TimeStamp
The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
2022-01-18
62 reads
The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
2022-01-18
62 reads
This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
2022-01-17
74 reads
NULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot
2022-01-17
66 reads
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.
2022-01-17
66 reads
When you are experiencing SQL Server Error Msg 3231, Level 16, State 1 while backing up SQL Database, it is important to troubleshoot the er
2022-01-17
510 reads
Is it possible to use COPY_ONLY backup for restoring differential backups? No, if you try to do so, SQL Server raises error Msg 3136, Level
2022-01-17
85 reads
Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:Program FilesWindowsPowerShellModules.'
2022-01-13
98 reads
Troubleshoot PowerShell-No match was found for the specified search criteria, module FailoverClusters
2022-01-13
72 reads
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
2022-01-12
70 reads
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
2022-01-12
158 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers