• Backup full et TLOG

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;

• restore

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];

• on compare sur la primaire le nombre de BDD versus nombre de BDD dans AG

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