SQL Cluster backups

Question

Hello all,

Recently we stood up a 3 SQL cluster (2 active hosts and 1 passive host). We have 2 virtual servers that host up the SQL instances. On one of the virtual servers (mars), we are running a default instance of SQL and on the other (pluto), we are running a named instance (lets say venus). I got the SQL backup to run on the default instance (mars), however I can't get the backup to run on pluto. In the save set section I have specified "MSSQL$VENUS:" and I have tried the following backup commands to no avail:
nsrsqlsv -S2
nsrsqlsv -a pluto -S2
nsrsqlsv -a pluto
I have the physical nodes that the virtual server is running on in the "remote connections" section and all looks ok. However, the backup fails without any detailed information. I am using the same user to run the backup as I am with the default instance.

If any one could provide some guidance, I would greatly appreciate it.

Thank you!

benzino1 · Answer

Could you please provide the information from applogs directory on the active node for service named pluto?

SigmaAdmin · Answer

Thank you for your response. When I run the job again to get the latest from the applog, it isn't updating the nsrsqlsv log so I don't believe the data in the file will be relavant any more...I do have what I am receiving from the email notifications however:pluto:MSSQL$VENUS: 1 retry attempted pluto:MSSQL$VENUS:: No full backups of this save set were found in the media database; performing a full backup* pluto:MSSQL$VENUS: [5812] 03/11/08 08:24:57 pluto is a SQL Virtual Server* pluto:MSSQL$VENUS: nsrsqlsv: Invalid SQL instance name in a cluster: MSSQL$VENUS:See the file C:\Program Files\Legato
sr	mp\sg\blank\sso.000040 for details. This file may be removed after Tue Mar 18 08:24:51 2008.I have checked the sso file it names but that only gives me information already mentioned in the email. When I connect to the SQL instance through management studio, I connect by typing in pluto\venus and everything works.Thanks again,

smora1 · Answer

Can you paste here the outcome of net start runned on physical node that contains venus instance?Thanks.

SigmaAdmin · Answer

I can run a client side backup successfully from the client SQL GUI, however the scheduled backups from the server do not work nor do they work through command prompt.Thanks for your help.

ble1 · Answer

Just out of curiosity, when you use client side GUI do you see it and can you do the backup?

ble1 · Answer

Did you try same command line as the one used by GUI? I believe you can see what is used from module log.

SigmaAdmin · Answer

Once I ran the backup from the client, I recognized that it was using just the MSSQL: saveset even though it is a named SQL instance. I then went back and re-tryed using only MSSQL: in the saveset field and it worked. My backups are now working fine which is very odd because I had attempted using this saveset before creating this post.

Thank you all for your help.

benzino1 · Answer

I used to have such situations with tech support for my electronic devices: at home NOT working, at the service point - WORKING

NetWorker

SQL Cluster backups

Was this post helpful?