Home Forums SQL Server 2005 Backups backup all databases in SQL 2008 RE: backup all databases in SQL 2008

  • January 20, 2012 at 8:56 am

    #1436566

    exec sp_msforeachdb 'if db_id(''?'')>4 backup database [?] to disk = ''C:\?.bak'' with init, compression;'