For a newly created cluster, there are many Event ID 1257 cluster events shown on Failover Cluster Manager.
Cluster network name resource failed registration of one or more associated
DNS name(s) because the access to update the secure DNS zone was denied.
cluster Network name: 'Cluster Name'
DNS Zone: 'DNS Zone'
Ensure that cluster name object (CNO) is granted permissions to Secure
DNS Zone.
Read more of this content when you subscribe today.
One data volume with data files is full, but the database whole size is relatively small. Finally it is because of Volume Shadow Copy Service (VSS),
To check VSS configuration and how much disk space used by VSS :
Disk Management –> Right Click C: Drive, then Properties –>Shadow Copies –> Settings.
https://sqlserverbuilds.blogspot.com/?_sm_au_=iHVkRTWZkQ346ff32sfHjK0s0FFFG#sql2017x
Choose an amount
Or enter a custom amount
Your contribution is appreciated.
Your contribution is appreciated.
Your contribution is appreciated.
DonateDonate monthlyDonate yearlyHandy script to list backup history details
Here is a script to list SQL server backup details for the last two weeks or 14 days.
SELECT
bs.database_name AS DatabaseName
,CASE
WHEN bs.database_name IN ('model','master','tempdb','msdb')
THEN 1
ELSE 0
END AS IsSystemDatabase
,bs.backup_start_date AS StartTime
,bs.backup_finish_date AS FinishTime
,bs.expiration_date AS ExpiryTime
,DATEDIFF(MI, bs.backup_start_date, bs.backup_finish_date) AS DurationMin
,DATEDIFF(SS, bs.backup_start_date, bs.backup_finish_date) AS DurationSec
,CASE bs.type
WHEN 'D' THEN 'Full Backup'
WHEN 'I' THEN 'Differential Database'
WHEN 'L' THEN 'Log'
WHEN 'F' THEN 'File/Filegroup'
WHEN 'G' THEN 'Differential File'
WHEN 'P' THEN 'Partial'
WHEN 'Q' THEN 'Differential partial'
END AS BackupType
,CAST(ROUND(((bs.backup_size/1024)/1024),2) AS decimal(10,2)) AS BackupSizeMb
,CAST(
ROUND(((bs.compressed_backup_size/1024)/1024),2)
AS decimal(18,2)) AS CompressedSizeMb
, ' '+ISNULL(
CASE WHEN has_bulk_logged_data = 1 THEN '| Bulk Logged Data' END
+ CASE WHEN is_snapshot = 1 THEN '| Snapshot' END
+ CASE WHEN is_readonly = 1 THEN '| Read-Only' END
+ CASE WHEN is_single_user = 1 THEN '| Single User' END
+ CASE WHEN has_backup_checksums = 1 THEN '| Backup Checksums' END
+ CASE WHEN is_damaged = 1 THEN '| Damaged' END
+ CASE WHEN begins_log_chain = 1 THEN '| Begins Log Chain' END
+ CASE WHEN has_incomplete_metadata = 1 THEN '| Incomplete Metadata' END
+ CASE WHEN is_force_offline = 1 THEN '| Force Offline' END
+ CASE WHEN is_copy_only = 1 THEN '| Copy Only' END
,'') AS BackupOptions
,bmf.physical_device_name AS BackupFile
,bs.user_name AS ExecUser
FROM msdb.dbo.backupmediafamily AS bmf
INNER JOIN msdb.dbo.backupset AS bs ON bmf.media_set_id = bs.media_set_id
WHERE DATEDIFF(dd, bs.backup_finish_date, GETDATE()) <= 14
ORDER by bs.backup_start_date DESC;
SELECT
db.name AS [Database Name],
mf.name AS [Logical Name],
mf.type_desc AS [File Type],
mf.name AS [Logical Name],
mf.state AS [ State ],
mf.state_desc AS [ State Desc],
mf.physical_name AS [Path],
CAST((mf.Size*8)/1024/1024 AS DECIMAL(18,1)) AS [Current Size(GB)],
CASE
WHEN mf.is_percent_growth >0 THEN
'TRUE'
ELSE
'FALSE'
END AS [Autogrowth],
CASE
WHEN mf.max_size = 0 THEN 'No growth is allowed'
WHEN mf.max_size = -1 THEN 'Unlimited'
ELSE
CAST(CAST(mf.max_size as BIGINT)*8/1024/1024 AS VARCHAR(30)) +' MB'
END AS [MaximumSize]
FROM
sys.master_files AS mf
INNER JOIN sys.databases AS db
ON db.database_id = mf.database_id
Order by db.name,mf.type_desc;
Make DBA Life Easy 