Topic: FCI (Failover Cluster Instance)
SQL Server DBA | Powershell |TSQL | Azure
Topic: Clusters
- is alive,
- like alive
1) Can we rename named instance name in SQL server? - No
/*
Note that Instance Name rename is unsupported. In named instance the server name is in format of ServerName\InstanceName. So, you can change it to NewName\InstanceName but NOT to ServerName\ NewInstanceName.
*/
2) when was the last time DBCC CHECKDB happned for specific db? - DBCC DBINFO (<Database_name123>) with tableresults
