Red Gate forums :: View topic - Multi-Server Install of Backup using SQL Multi Script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

Multi-Server Install of Backup using SQL Multi Script

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Jason Cook



Joined: 01 Jun 2006
Posts: 180
Location: Cambridge, UK

PostPosted: Mon Jun 16, 2008 4:05 pm    Post subject: Multi-Server Install of Backup using SQL Multi Script Reply with quote

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-tools/installing-sql-backup-on-multiple-servers-using-sql-multi-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
Back to top
View user's profile Send private message Send e-mail
nephila



Joined: 02 Nov 2007
Posts: 4

PostPosted: Thu Aug 07, 2008 1:27 pm    Post subject: Updated script Reply with quote

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
Back to top
View user's profile Send private message
DonMan



Joined: 25 Aug 2008
Posts: 62

PostPosted: Mon Aug 25, 2008 9:58 pm    Post subject: SqbServerSetup.exe Flags Reply with quote

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.
Back to top
View user's profile Send private message
Jason Cook



Joined: 01 Jun 2006
Posts: 180
Location: Cambridge, UK

PostPosted: Wed Sep 10, 2008 1:44 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
DonMan



Joined: 25 Aug 2008
Posts: 62

PostPosted: Thu Sep 11, 2008 6:42 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Jason Cook



Joined: 01 Jun 2006
Posts: 180
Location: Cambridge, UK

PostPosted: Thu Sep 18, 2008 11:04 am    Post subject: Reply with quote

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:
/VERYSILENT /SUPPRESSMSGBOXES /SQBMINIMAL

Three flags combined perform a silent install

Code:
/I (instance)

Instance Name (leave blank for default instance)

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

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

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

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

Code:
/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:
/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:
/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
Back to top
View user's profile Send private message Send e-mail
tracy16



Joined: 14 Nov 2008
Posts: 1

PostPosted: Fri Nov 14, 2008 4:02 am    Post subject: Re: Multi-Server Install of Backup using SQL Multi Script Reply with quote

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-tools/installing-sql-backup-on-multiple-servers-using-sql-multi-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 Smile
keyword research
Back to top
View user's profile Send private message
mdgraves



Joined: 21 Sep 2007
Posts: 42

PostPosted: Tue Apr 03, 2012 8:19 pm    Post subject: Reply with quote

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 *********
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group