Powershell script to read in database names and create 3 text files

Need a powershell script as described below that can ingest a list of database names, then output 3 text files. Just needs to be able to read the file in from the local working directory and output the 3 new text files to the same local working dirctory 1)take input from a text list containing a list of database names: Databasenumber1 Databasenumber2 Databasenumber3 read the database names from the text file and output to a new text file, each database name needs 2 lines as shown below: Backup-SqlDatabase -Database "Databasenumber1" -BackupFile "\\sqlserver1\sharetest\[login to view URL]" -ServerInstance "sqlserver1" Backup-SqlDatabase -Database "Databasenumber1" -BackupAction "Log" -BackupFile "\\sqlserver\sharetest\[login to view URL]" -ServerInstance "sqlserver1" Backup-SqlDatabase -Database "Databasenumber2" -BackupFile "\\sqlserver1\sharetest\[login to view URL]" -ServerInstance "sqlserver1" Backup-SqlDatabase -Database "Databasenumber2" -BackupAction "Log" -BackupFile "\\sqlserver\sharetest\[login to view URL]" -ServerInstance "sqlserver1" Backup-SqlDatabase -Database "Databasenumber3" -BackupFile "\\sqlserver1\sharetest\[login to view URL]" -ServerInstance "sqlserver1" Backup-SqlDatabase -Database "Databasenumber3" -BackupAction "Log" -BackupFile "\\sqlserver\sharetest\[login to view URL]" -ServerInstance "sqlserver1" Then also need to read in the same source text list containing the database names and output another file with this content: EXECUTE AS login='USERNAME; RESTORE DATABASE Databasenumber1 FROM DISK = '\\sqlserver1\sharetest\[login to view URL]' WITH NORECOVERY; REVERT; GO RESTORE LOG Databasenumber1 FROM DISK = '\\sqlserver1\sharetest\[login to view URL]' WITH NORECOVERY, FILE = 1 GO EXECUTE AS login='USERNAME; RESTORE DATABASE Databasenumber2 FROM DISK = '\\sqlserver1\sharetest\[login to view URL]' WITH NORECOVERY; REVERT; GO RESTORE LOG Databasenumber2 FROM DISK = '\\sqlserver1\sharetest\[login to view URL]' WITH NORECOVERY, FILE = 1 GO EXECUTE AS login='USERNAME; RESTORE DATABASE Databasenumber3 FROM DISK = '\\sqlserver1\sharetest\[login to view URL]' WITH NORECOVERY; REVERT; GO RESTORE LOG Databasenumber2 FROM DISK = '\\sqlserver3\sharetest\[login to view URL]' WITH NORECOVERY, FILE = 1 GO 3rd text file output, section below for each of the database names from the original list: USE [master] GO ALTER AVAILABILITY GROUP [AGGROUP1] ADD DATABASE [Databasenumber1]; GO :ConnectDB2 begin try declare @conn bit declare @count int declare @replica_id uniqueidentifier declare @group_id uniqueidentifier set @conn = 0 set @count = 30 -- wait for 5 minutes if (serverproperty('IsHadrEnabled') = 1) and (isnull((select member_state from master.sys.dm_hadr_cluster_members where upper(member_name COLLATE Latin1_General_CI_AS) = upper(cast(serverproperty('ComputerNamePhysicalNetBIOS') as nvarchar(256)) COLLATE Latin1_General_CI_AS)), 0) <> 0) and (isnull((select state from master.sys.database_mirroring_endpoints), 1) = 0) begin select @group_id = ags.group_id from master.sys.availability_groups as ags where name = N'AGGROUP1' select @replica_id = replicas.replica_id from master.sys.availability_replicas as replicas where upper(replicas.replica_server_name COLLATE Latin1_General_CI_AS) = upper(@@SERVERNAME COLLATE Latin1_General_CI_AS) and group_id = @group_id while @conn <> 1 and @count > 0 begin set @conn = isnull((select connected_state from master.sys.dm_hadr_availability_replica_states as states where states.replica_id = @replica_id), 1) if @conn = 1 begin -- exit loop when the replica is connected, or if the query cannot find the replica status break end waitfor delay '00:00:10' set @count = @count - 1 end end end try begin catch -- If the wait loop fails, do not stop execution of the alter database statement end catch ALTER DATABASE [Databasenumber1] SET HADR AVAILABILITY GROUP = [AGGROUP1]; GO