Back up multiple databases v4.6

chrisotte

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:
\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 \BACKUPS\FULL_(local)_*_20060823_000246.sqb

HJoyce

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"'

chrisotte

Thanks!

I knew it was a syntax issue...problem solved.