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

Sign In or Register to comment.