Ceci est une ancienne révision du document !

---

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

#### 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