Home Forums SQL Server 2005 Administering script to find all databases ,which are not in full recovery mode RE: script to find all databases ,which are not in full recovery mode

  • April 29, 2008 at 7:38 am

    #808332

    I found for SQL server 2000 now.

    Here is the script

    SELECT [name] AS [DatabaseName], CONVERT(SYSNAME, DATABASEPROPERTYEX(N''+ [name] + '', 'Recovery')) AS [RecoveryModel] FROM master.dbo.sysdatabases where CONVERT(SYSNAME, DATABASEPROPERTYEX(N''+ [name] + '', 'Recovery'))<>'full'