Red Gate forums :: View topic - sqlbackup.exe
Return to www.red-gate.com RSS Feed Available

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

sqlbackup.exe

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kterry



Joined: 09 Jan 2014
Posts: 1

PostPosted: Thu Jan 09, 2014 8:58 pm    Post subject: sqlbackup.exe Reply with quote

We have a windows 2012 R2 cluster, sql 2012, with two nodes, call them:
ServerA
ServerB
Sql virtual name: Sql_Cluster

We log ship some databases to above cluster, or will be, we're setting up/testing this now. I've run into a problem trying to run command line of sql backup (SqlBackupC.exe).
We only use default instances, don't have any sql servers with a named instance. On our current servers (not the cluster ) we can run :
SqlBackupC.exe -SQL "RESTORE LOG [DB] FROM DISK = [E:\backup\DB_10140108_123550_LOG.sqb]
WITH STANDBY = [E:\backup\StandByFiles\DB.dat], PASSWORD = [DBPWD], MOVETO=[Complete\db]" -E

and will run fine.
If I run same script on our cluster, I get error
SQL error 17: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Server :
Windows authentication
1/9/2014 7:48:51 AM: Failed to connect to SQL Server instance:

My user account is a sys admin on this sql. It looks to me like it is trying to use machine name as name of sql server, so trying to connect to sql named: serverA, we don't have that, since is cluster, sql is called sql_cluster. In trying to force it to connect to proper sql name, I looked for a -S or some parameter to pass in server name, but only saw -I for instance name. if i try -I and put in sql_cluster, it fails, looking for server: serverA/sql_cluster, we don't have named instance like that so that fails.
If a use -I (local) it works,
Somehow it uses different method to find sql server name if I omit it, different than if I pass -I (local) ? That seems strange, so maybe I'm missing something? I would expect all clusters to have this make up, where have 2 + servers, and sql on it but w/ diff name than the actual server name. Might our cluster not be set up right?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Fri Jan 10, 2014 8:26 am    Post subject: Reply with quote

It's a bug in SQL Backup when the default instance is a clustered instance. The workaround is as you mentioned: use the -I parameter with (local) or . i.e.

sqlbackupc -sql "BACKUP ..." -I (local)

or

sqlbackupc -sql "BACKUP ..." -I .

A bug report has been raised (SB-5555).
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
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