Home Forums SQL Server 2005 Backups What system databases do I need to backup? RE: What system databases do I need to backup?

  • Print this out and hang it on your wall: BACKUP ALL THE DATABASES

    You can backup the resource database's files through a simple robocopy script. Tempdb is the only database that you shouldn't back up.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]