ADSM-L

Re: Can't access TDP SQL /fileinfo metadata

2002-01-09 02:36:37
Subject: Re: Can't access TDP SQL /fileinfo metadata
From: Joel Fuhrman <joelf AT CAC.WASHINGTON DOT EDU>
Date: Tue, 8 Jan 2002 23:33:35 -0800
We had a similar problem which occurs because the sql server name
has become NULL.  Here is what was done to correct the problem on our server
named isntwarehouse:

In sql from TOOLS menu,
     Select Sql Server Query Analyzer:

    select @@servername
            NULL (server name was corrupted.)

    sp_dropserver 'ISNTWAREHOUSE'

    sp_addserver 'ISNTWAREHOUSE',local

    I bounced the SQL Server.

    check server name by select @@servername
    It shows 'ISNTWAREHOUSE' as SQL server name.

On Tue, 8 Jan 2002, Bill Smoldt wrote:

> I have several TDP SQL agents backing up Microsoft SQL 2000.  Two of them
> can't retrieve the fileinfo data with the command:
>
> tdpsqlc query tsm Northwind full /fileinfo
>
> They return the error ACO0151E.
>
> ACO0151E Errors occurred while processing the request.
> Explanation: Attempting to process the request entered, an error occurred.
>
> System Action: Processing ends.
>
> User Response: Attempt to determine the source of the errors from viewing
> the log file. Correct the problems and try running the command again.
>
> And there is nothing in the log file pertaining to the error.  From the GUI,
> attempting a RELOCATE yields a blank window, with no files listed.
>
> I haven't done anything to ensure the metadata stays in a disk pool, but I
> don't believe that it would cause this error if it were on tape - it should
> simply take longer to complete the command.  Is that correct?
>
> Any ideas how I can fix this?
>
> Thanks,
>
> Bill Smoldt
> STORServer, Inc.
>
<Prev in Thread] Current Thread [Next in Thread>