What are the challenges you face when working across database platforms? Take the survey
Options

Back up multiple databases v4.6

chrisottechrisotte Posts: 3
edited August 23, 2006 11:13AM in SQL Backup Previous Versions
I am having issues backing up all databases. Thoughts?

OS: W2k3 SP1

SQL Svr: 2k5

Syntax:

master..sqlbackup N'-SQL "BACKUP DATABASE [*] TO DISK = ''D:\BACKUPS\<AUTO>'' WITH NAME = ''<AUTO>'', INIT, ERASEFILES = 5, COMPRESSION = 2"'

Results:

Backing up * (full database) to:
D:\BACKUPS\FULL_(local)_*_20060823_000246.sqb

Error 880: BACKUP DATABASE permission denied in database: (*)
SQL error 911: Could not locate entry in sysdatabases for database '*'. No entry found with that name. Make sure that the name is entered correctly.

SQL Backup exit code: 880
SQL error code: 911

exitcode 880
sqlerrorcode 911
filename01 D:\BACKUPS\FULL_(local)_*_20060823_000246.sqb

Comments

  • Options
    It should be DATABASES not DATABASE to use * to mean all databases.

    e.g. master..sqlbackup N'-SQL "BACKUP DATABASES [*] TO DISK = ''D:\BACKUPS\<AUTO>'' WITH NAME = ''<AUTO>'', INIT, ERASEFILES = 5, COMPRESSION = 2"'
    Helen Joyce
    SQL Backup Project Manager
    Red Gate Software
  • Options
    Thanks!

    I knew it was a syntax issue...problem solved.
Sign In or Register to comment.