Skip to main content

Command Palette

Search for a command to run...

Topic: FCI (Failover Cluster Instance)

Published
•1 min read•View as Markdown
P

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