back up all system databases

dwjongbloeddwjongbloed Posts: 30
edited April 3, 2008 9:22AM in SQL Backup Previous Versions
:?:

is there a way to back up all the system databases via 1 script line like you can do single databases? Or do I have to do each system database seperately as in the script?
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    via 1 script line like you can do single databases
    Do you mean the BACKUP DATABASES [*] ... syntax?

    The only way to back up all system databases using a single script is to name each of the system database e.g.
    EXEC master..sqlbackup 'sql "BACKUP DATABASES [master, model, msdb] TO DISK = ...
    You may need to add more depending on whether you are running replication and want to include the system replication databases.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • dwjongbloeddwjongbloed Posts: 30
    I believe this is exactly what I'm looking for.
    · Share on Twitter
Sign In or Register to comment.