How can we help you today? How can we help you today?

back up all system databases

:?:

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?
dwjongbloed
0

Comments

2 comments

Sort by
  • petey
    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.
    petey
    0
  • dwjongbloed
    I believe this is exactly what I'm looking for.
    dwjongbloed
    0

Add comment

Please sign in to leave a comment.