I was asked a question about backups on a customer and found the answer which is semi tricky from the error you receive. Since I don’t see this error in any internal FAST ticketing system, alias or Bing I’ll
send it out and hopefully save someone’s remaining hair someday.
From the technet backup article:
Prerequisites for the SQL database
The user who runs the backup and restore script must have sysadmin permissions on the FAST Search Server 2010 for SharePoint administration database.
This is what it looks like if your FAST admin user does not have SQL sysadmin perms which is not a prereq for FS4SP to run:
backup -action "full" -force -backuppath \\HOST01\E$\FS4SP
[2011-08-04 10:27:16] VERBOSE Testing PowerShell Remoting availability.
cmdlet Get-Credential at command pipeline position 1
Supply values for the following parameters:
[2011-08-04 10:27:46] VERBOSE Initiating Full backup
[2011-08-04 10:27:48] VERBOSE The path \\HOST01\E$\FS4SP already exists, overwriting.
[2011-08-04 10:27:48] VERBOSE SQL meta data will be stored in \\HOST01\E$\FS4SP
[2011-08-04 10:27:48] VERBOSE Backing up fs4sp-d to fs4sp-d20110804102748.bak
[2011-08-04 10:27:49] VERBOSE SQL backup completed without error.
: An exception occurred while executing a Transact-SQL statement or batch.
+ CategoryInfo : NotSpecified: (:) [format-default], ExecutionFailureException
+ FullyQualifiedErrorId :