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\nsr\tmp\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.
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.
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.
benzino1
2 Intern
•
244 Posts
0
March 11th, 2008 02:00
SigmaAdmin
1 Rookie
•
39 Posts
0
March 11th, 2008 05:00
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\nsr\tmp\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
253 Posts
0
March 11th, 2008 07:00
Thanks.
SigmaAdmin
1 Rookie
•
39 Posts
0
March 11th, 2008 10:00
Thanks for your help.
ble1
4 Operator
•
14.4K Posts
0
March 11th, 2008 10:00
ble1
4 Operator
•
14.4K Posts
0
March 11th, 2008 15:00
SigmaAdmin
1 Rookie
•
39 Posts
0
March 12th, 2008 06:00
Thank you all for your help.
benzino1
2 Intern
•
244 Posts
0
March 12th, 2008 07:00