FB Options - SQLMaint.exe? Where is it?

FinalBuilder Discussion
1

I'm trying to do a SQL 2005 Backup with FB. I'm getting the error "SQL Server Options: Path to SQLMaint.exe has not been set." I found OSQL.exe and SQLCMD.exe in "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\" but I can't find SQLMaint.exe.

Where would I look for SQLMaint.exe or how can I work around the problem?

Thanks

Error.bmp

2

One extra note: The database I am trying to backup is on a sql server and not on my build machine.

Thanks again...

3

Hi Bob,

You’ll need to have SQLMaint.exe installed on your build machine. I’m not sure what part of the SQL Server installer is required though.

I found SQLMaint.exe in this location on our server:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

hth.

4
Thanks that did it.

I copied the sqlmaint.exe and sqlmaint.rll files to my build machine "C:\Program Files\Microsoft SQL Server" directory and set the FB SQLMAINT Location path.

I received an error at first but that was because the process didn't have permissions for the backup destination.

Thanks again!