Free for PREMIUM members
[Last Call] Learn how to a build a cloud-first strategyRegister Now
EXEC sp_MSForEachDB 'ALTER DATABASE [?] SET RECOVERY FULL';
Open in new window
Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database
EXEC sp_MSforeachdb 'IF [?] NOT IN (''master'', ''model'', ''msdb'', ''tempdb'')
ALTER DATABASE [?] SET RECOVERY FULL'
Msg 207, Level 16, State 1, Line 1
Invalid column name 'sandsjh1_123_db'.
December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.