Multi-Server Install of Backup using SQL Multi Script

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Multi-Server Install of Backup using SQL Multi Script

Postby Jason Cook » Mon Jun 16, 2008 4:05 pm

Recently, we've had a number of customers asking how to install the SQL Backup server components on multiple servers without doing it manually server by server.

We are pleased to announce that an article on this topic (using SQL Multi Script) has been published on the Simple Talk website, and can be found at:

http://www.simple-talk.com/sql/sql-tool ... ti-script/

We appreciate your feedback on the article, which can be provided via the comment form at the bottom of the article.

If there are other SQL Backup-themed articles you would like to see, feel free to post on this thread and we will note them for future consideration.

Thanks,
Jason
Jason Cook
 
Posts: 180
Joined: Thu Jun 01, 2006 9:59 am
Location: Cambridge, UK

Updated script

Postby nephila » Thu Aug 07, 2008 1:27 pm

We have had to extend the script to deal with the following issues we found:

a) spaces in path names

b) removing service if it was already previously installed, works but Im sure would be beneficial to uninstall silently if a prior version was found

c) post install we amended the script to add/modify registry keys to provide finer level of customization

Excellent script and has already saved us a vast amount of time, great job
nephila
 
Posts: 4
Joined: Fri Nov 02, 2007 9:03 pm

SqbServerSetup.exe Flags

Postby DonMan » Mon Aug 25, 2008 9:58 pm

Are there any other flags for SqbServerSetup.exe beyond what is shown in the article? In particular, I'm looking for a flag to specify a different non-default installation directory and a different non-default path for the CE database.
DonMan
 
Posts: 62
Joined: Mon Aug 25, 2008 9:48 pm

Postby Jason Cook » Wed Sep 10, 2008 1:44 pm

Hi DonMan,
While there are other flags available, unfortunately if doing a silent install you are currently forced to install to the default directory. I'll pass the suggestion on to our development team who will consider it for a future release.

Thanks,
Jason
Jason Cook
 
Posts: 180
Joined: Thu Jun 01, 2006 9:59 am
Location: Cambridge, UK

Postby DonMan » Thu Sep 11, 2008 6:42 pm

I did manage to work around the issue by using reg add command in a batch file to chage values after the install in my installation script. But I am of the opinion that any parameter that can be changed in the installation GUI should be available to change using an unattended install.

If a complete list of all available flags could be provided, I may find that useful for other scripting options.

Thanks.
DonMan
 
Posts: 62
Joined: Mon Aug 25, 2008 9:48 pm

Postby Jason Cook » Thu Sep 18, 2008 11:04 am

Hi DonMan,

The following list provides the flags that are currently available for the Server Components Installer, while they have been tested they are 'unsupported' and may be changed, modified or removed in a future release:

Code: Select all
/VERYSILENT /SUPPRESSMSGBOXES /SQBMINIMAL

Three flags combined perform a silent install

Code: Select all
/I (instance)

Instance Name (leave blank for default instance)

Code: Select all
 /SVCUSER (name) /SVCPW (password)

Username and Password for the Windows Service (leave blank to use local system)

Code: Select all
/SQLUSER (name) /SQLPW (password)

Username and Password for the SQL Authentication (leave blank to use the windows authentication of the service account)

Code: Select all
/CLUSTERINSTALL /CLUSTERUSER (name) /CLUSTERPW (password)

Perform a clustered install. The cluster credentials must be an administrator on the cluster. If installing on a cluster, the instance name must still be the name as it is on the local machine (e.g. "SQL2005").

Code: Select all
/LOG

Provides debugging and other log information during the install, the log file is stored in the current user's temporary directory (%current_user%\\Local Settings\\Temp\\Setup Log yyyy-mm-dd #nnn.txt)

Code: Select all
/EXITCODEFILE

An exit code that explains what the status of the installation was, more information is provided in the script of the simple talk article.

Hope that helps,
Jason
Jason Cook
 
Posts: 180
Joined: Thu Jun 01, 2006 9:59 am
Location: Cambridge, UK

Re: Multi-Server Install of Backup using SQL Multi Script

Postby tracy16 » Fri Nov 14, 2008 4:02 am

Jason Cook wrote:Recently, we've had a number of customers asking how to install the SQL Backup server components on multiple servers without doing it manually server by server.

We are pleased to announce that an article on this topic (using SQL Multi Script) has been published on the Simple Talk website, and can be found at:

http://www.simple-talk.com/sql/sql-tool ... ti-script/

We appreciate your feedback on the article, which can be provided via the comment form at the bottom of the article.

If there are other SQL Backup-themed articles you would like to see, feel free to post on this thread and we will note them for future consideration.

Thanks,
Jason



thanks jason for this article. back up is the most important thing while you work with technology. i would like to see more articles from you but i dont have a demand of any specific subject. whenver possible please keep putting up these write ups it really helps.

thanks again
tracy16 :)
keyword research
tracy16
 
Posts: 1
Joined: Fri Nov 14, 2008 3:17 am

Postby mdgraves » Tue Apr 03, 2012 8:19 pm

I am attempting to run the silent install for the latest update to SQL Backup 6.5.

Below is my command string (server names, logins and passwords masked).

When I run, I get the "select the tools to install" window pop-up. How can I avoid this / any interaction windows?

"D:\\DBA_Installs\\SQL Backup 6.5\\v6.5.0.73\\SQL_Backup_6.5.0.73.exe" /VERYSILENT /SUPPRESSMSGBOXES /SQBMINIMAL /LOG /SVCUSER *****\\***** /SVCPW ******/I *********
mdgraves
 
Posts: 42
Joined: Fri Sep 21, 2007 7:56 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest