Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.
--declare all variables used declare @tblName varchar(150) declare @fields varchar(150) declare @sql varchar (2000) DECLARE c1 CURSOR READ_ONLY FOR (select TABLE_NAME from information_schema.columns where TABLE_CATALOG = 'SiteMinder_FULL' group by TABLE_NAME ) OPEN c1 FETCH NEXT FROM c1 INTO @tblName WHILE @@FETCH_STATUS = 0 BEGIN select COLUMN_NAME from information_schema.columns where TABLE_NAME = @tblName set @sql = 'select '+@fields+' into ' + @tblName + ' from OCX..SST.' + @tblName + '' exec (@sql) ----first cursor FETCH NEXT FROM c1 INTO @tblName END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.