Veritas-bu

[Veritas-bu] SQL Backups fail with status 6

2003-02-11 10:58:46
Subject: [Veritas-bu] SQL Backups fail with status 6
From: david AT datastaff DOT com (David A. Chapa)
Date: Tue, 11 Feb 2003 10:58:46 -0500
Ask the DBA to let you try it with the sa account for testing purposes and see 
if that works.

if it does, then it is a permissions issue with the account he/she set up.

David

Quoting "WEAVER, Simon" <Simon.WEAVER AT astrium-space DOT com>:

> Hello,
> I am having a real nightmare with the backup of SQL2000 on NT.
> I created an ODBC and used an account that has access to SQL2k.
> 
> Initially, when I kicked the backups off, I was getting a constant status
> code of 2.
> I tracked this down to the SQL batch file and made the necessary
> alterations
> for my SQL Server.
> 
> Now it continues to fail with status 6 - Its implying that the account does
> not have permissions to SQL but according to the SQL Guru here, he has
> given
> the account access to backup the DB's
> 
> Does anyone have any ideas on a possible way forward?
> 
> Thank you very much
> 
> Simon Weaver
> NT Domain Administrator
> Ext. 5544
> Tel: 02392-705544 (Direct Dial)
> Simon.Weaver AT Astrium-Space DOT com
> 
> ...
> This email is for the intended addressee only.
> If you have received it in error then you must not use, retain, disseminate
> or otherwise deal with it.  Please notify the sender by return email.
> The views of the author may not necessarily constitute the views of Astrium
> Limited.
> Nothing in this email shall bind Astrium Limited in any contract or
> obligation.
> 
> Astrium Limited, Registered in England and Wales No. 2449259
> Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS,
> England
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>