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

  • January 20, 2012 at 9:06 am

    #1436576

    padhis (1/20/2012)

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

    Does the same thing but isn't support by Microsoft 😛

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified