Condividi tramite

FS4SP Backup and Restore error

  • Articolo

Good Day,

 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:

https://technet.microsoft.com/en-us/library/ff460223.aspx

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:

 

PS E:\FASTSearch\bin>
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:

Credential

[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.

format-default
: An exception occurred while executing a Transact-SQL statement or batch.

    + CategoryInfo : NotSpecified: (:) [format-default], ExecutionFailureException

    + FullyQualifiedErrorId :
Microsoft.SqlServer.Management.Common.ExecutionFailureException,Microsoft.PowerShell.Commands.FormatDefaultCommand

 

 

 -Thanks

  -Kris

Comments

  • Anonymous
    December 06, 2011
    TechNet article says the account must have Sysadmin permission on the database. Since sysadmin is a server role, I do not know how that is possible on a database and would seem to be a security weakiness for the entire SQL server.