• Lowell

    SSC Guru

    Points: 323463

    here's something i use on my dev server...don't need anything in FULL recovery mode on that server at all...it's a play ground.:

    USE MASTER

    declare

    @isql varchar(2000),

    @dbname varchar(64)

    declare c1 cursor for select name from master..sysdatabases where name not in ('master','model','msdb','tempdb')

    open c1

    fetch next from c1 into @dbname

    While @@fetch_status <> -1

    begin

    select @isql = 'ALTER DATABASE @dbname SET AUTO_CLOSE OFF'

    select @isql = replace(@isql,'@dbname',@dbname)

    print @isql

    exec(@isql)

    select @isql = 'ALTER DATABASE @dbname SET RECOVERY SIMPLE'

    select @isql = replace(@isql,'@dbname',@dbname)

    print @isql

    exec(@isql)

    select @isql='USE @dbname checkpoint'

    select @isql = replace(@isql,'@dbname',@dbname)

    print @isql

    exec(@isql)

    fetch next from c1 into @dbname

    end

    close c1

    deallocate c1

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!