* Backup full et TLOG
<code TSQL>
BACKUP DATABASE [IVANTI_SECURITYCONTROLS]			to disk='\\GVASQLCL1\1-Temp_AlwaysOnBuild\IVANTI_SECURITYCONTROLS_BackupFull_10-04-2025.bak' with stats=2;

BACKUP LOG [IVANTI_SECURITYCONTROLS]			to disk='\\GVASQLCL1\1-Temp_AlwaysOnBuild\IVANTI_SECURITYCONTROLS_BackupLog_10-04-2025.bak' with  stats=2;
</code>


  * restore
<code TSQL>
restore filelistonly from disk='\\GVASQLCL1\1-Temp_AlwaysOnBuild\IVANTI_SECURITYCONTROLS_BackupFull_10-04-2025.bak';

RESTORE DATABASE [IVANTI_SECURITYCONTROLS] from disk='\\GVASQLCL1\1-Temp_AlwaysOnBuild\IVANTI_SECURITYCONTROLS_BackupFull_10-04-2025.bak'
with move 'IVANTI_SECURITYCONTROLS' to 'e:\SQL_DATA\IVANTI_SECURITYCONTROLS.mdf',
move 'IVANTI_SECURITYCONTROLS_log' to 'f:\SQL_LOGS\IVANTI_SECURITYCONTROLS_log.ldf',
norecovery, stats=2;


RESTORE LOG  [IVANTI_SECURITYCONTROLS] from  disk='\\GVASQLCL1\1-Temp_AlwaysOnBuild\IVANTI_SECURITYCONTROLS_BackupLog_10-04-2025.bak'
with norecovery;


ALTER DATABASE [IVANTI_SECURITYCONTROLS] SET HADR AVAILABILITY GROUP = [gvasqlag1];
</code>

  * on compare sur la primaire le nombre de BDD versus nombre de BDD dans AG
<code TSQL>
select count(name)from sys.databases
where name not in('master','model','msdb','tempdb');


select count(distinct(database_name))  from master.sys.dm_hadr_database_replica_cluster_states
</code>