Tuesday, March 27, 2012
Backup Failed? cannot find deleted database
I have MSSQL 2000 and I am using Veritas Backup Exec 9.1 to backup
SQL.
I resently deleted a Database and now the JOB fails with error:
0xa000fe09 - DBASE_NAME cannot find/connect to database or its
directories.
The database is not listed in the job selection either? Is there
anyway I can stop Veritas reporting the failure for a non-exsistant
database?
TIAIn the backup selections list, select Text view, which will then give you a
list of all the things being backed up (rather than the graphical display),
you should find that the db which you have deleted is listed there, so you
can manually delete it from the list.
The graphical display won't display it, as the items to be backed up are
displayed live from the server, so since the db is no longer there, it can't
display it, and therefore can't show that it is selected. It's a fairly well
known "feature" of all versions of Backup Exec.
Keith
"Carlos" <carlos_kennerley@.hotmail.com> wrote in message
news:fb6dfb4d.0410260154.2dd334ad@.posting.google.com...
> Hi,
> I have MSSQL 2000 and I am using Veritas Backup Exec 9.1 to backup
> SQL.
> I resently deleted a Database and now the JOB fails with error:
> 0xa000fe09 - DBASE_NAME cannot find/connect to database or its
> directories.
> The database is not listed in the job selection either? Is there
> anyway I can stop Veritas reporting the failure for a non-exsistant
> database?
> TIA
Backup Failed? cannot find deleted database
I have MSSQL 2000 and I am using Veritas Backup Exec 9.1 to backup
SQL.
I resently deleted a Database and now the JOB fails with error:
0xa000fe09 - DBASE_NAME cannot find/connect to database or its
directories.
The database is not listed in the job selection either? Is there
anyway I can stop Veritas reporting the failure for a non-exsistant
database?
TIA
In the backup selections list, select Text view, which will then give you a
list of all the things being backed up (rather than the graphical display),
you should find that the db which you have deleted is listed there, so you
can manually delete it from the list.
The graphical display won't display it, as the items to be backed up are
displayed live from the server, so since the db is no longer there, it can't
display it, and therefore can't show that it is selected. It's a fairly well
known "feature" of all versions of Backup Exec.
Keith
"Carlos" <carlos_kennerley@.hotmail.com> wrote in message
news:fb6dfb4d.0410260154.2dd334ad@.posting.google.c om...
> Hi,
> I have MSSQL 2000 and I am using Veritas Backup Exec 9.1 to backup
> SQL.
> I resently deleted a Database and now the JOB fails with error:
> 0xa000fe09 - DBASE_NAME cannot find/connect to database or its
> directories.
> The database is not listed in the job selection either? Is there
> anyway I can stop Veritas reporting the failure for a non-exsistant
> database?
> TIA
Backup Failed? cannot find deleted database
I have MSSQL 2000 and I am using Veritas Backup Exec 9.1 to backup
SQL.
I resently deleted a Database and now the JOB fails with error:
0xa000fe09 - DBASE_NAME cannot find/connect to database or its
directories.
The database is not listed in the job selection either? Is there
anyway I can stop Veritas reporting the failure for a non-exsistant
database?
TIAIn the backup selections list, select Text view, which will then give you a
list of all the things being backed up (rather than the graphical display),
you should find that the db which you have deleted is listed there, so you
can manually delete it from the list.
The graphical display won't display it, as the items to be backed up are
displayed live from the server, so since the db is no longer there, it can't
display it, and therefore can't show that it is selected. It's a fairly well
known "feature" of all versions of Backup Exec.
Keith
"Carlos" <carlos_kennerley@.hotmail.com> wrote in message
news:fb6dfb4d.0410260154.2dd334ad@.posting.google.com...
> Hi,
> I have MSSQL 2000 and I am using Veritas Backup Exec 9.1 to backup
> SQL.
> I resently deleted a Database and now the JOB fails with error:
> 0xa000fe09 - DBASE_NAME cannot find/connect to database or its
> directories.
> The database is not listed in the job selection either? Is there
> anyway I can stop Veritas reporting the failure for a non-exsistant
> database?
> TIA
Sunday, February 12, 2012
Backspace doesn't work in SSMS
This week, I installed SQL2K5 (SP2) on two W2K servers.
On 1 server (W2K Server), I deleted SQL2K and installed SQL2K5 using the default instance. This server works OK.
On another machine (W2K Pro), I retained my SQL2K default instance of the SQL2K db engine and installed SQL2K5 as a new named instance (i.e. SQL2005).
When I go into SSMS on the 2nd machine and edit an sql script, the backspace, home, delete (and other directional key) keys from the keyboard do absolutely nothing.
SSMS on the 1st machine works just fine.
I have looked at SSMS's customizations and tried several changes to no avail...
Does anyone know what I need to do in SSMS?
TIA!!!
you may need to re-install the client tool... select only workstation components from the CD and re-install it...
Madhu
|||Have you changed any shortcut keys on the client tools of this installation?