Post reply

script to find all databases ,which are not in full recovery mode

  • April 28, 2008 at 7:41 pm

    #125072

    i am looking for a script ,when executed on a server ,will list out all databases in full recovery mode.

    thanks

    jacky

  • April 28, 2008 at 9:06 pm

    #808105

    1 of many ways...

    select name from sys.databases where recovery_model = 1

    NJ

  • April 29, 2008 at 7:24 am

    #808308

    This will work only with sql server 2005, how about sql server 2000?

  • 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'

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply