SQL Restore - Veritas Backup Exec

This is a discussion on SQL Restore - Veritas Backup Exec ; I am assembling a disaster recovery server for an Microsoft SQL Server. This server is a Proliant 3000 with one internal DLT 40/80GB and Windows NT 4.0 SP6A, SQL Server 7.0 SP2 and Veritas Backup Exec 7.3 Rev 2575. The ...

+ Reply to Thread
Results 1 to 3 of 3

Thread: SQL Restore

  1. SQL Restore

    I am assembling a disaster recovery server for an Microsoft SQL Server. This
    server is a Proliant 3000 with one internal DLT 40/80GB and Windows NT 4.0
    SP6A, SQL Server 7.0 SP2 and Veritas Backup Exec 7.3 Rev 2575.

    The Production Server is a Proliant 6400R with a library Compaq, with one
    drive DLT 35/70 and the same software.

    The problem comes out when I restore a tape of the Production Server in the
    Disaster recovery Server. The SQL Server have 10 databases without
    considering the system ones (master, temp, etc.)

    Some of the databases couldn't be restored and the following happens:

    The job starts in the usual way, it starts to read the tape and when it
    arrives approximately to 800KB it stays there for hours. The DLT led (tape
    in use) stays activated permanently.

    The databases that couldn't be restored don't have anything in particular,
    and we have another ones that are bigger or smaller, and it could be
    restored

    The versions of the DLT firmware are:

    Production:

    Compaq 35/70 GB DLT LIB Rev 4.04 Serial mn012281

    Compaq 35/70 GB LDRV Rev 2150 (V80) Serial CX92054925



    Disaster Recovery

    Compaq 40/80 GB DLT DRV Rev 011A (V26) Serial CXA44P0142

    I could do another tests, which succeeded:

    1.. Restoring the same tape from the Production Server (DTL 35/70) to the
    Development Server.
    2.. Doing the backup of the databases of the Supporting Server from
    itself, using the same back up software and the DLT 40/80
    3.. Restoring the tape resulting of the 2nd step in the Supporting Server.
    I think the problem is not in the SQL Server, or in backup software. And it
    seems that the DLT 40/80 is not compatible at all with recorded tapes in DLT
    35/70.

    Any idea ??






  2. Re: SQL Restore


    Error messages in BE logs?


    "Gustavo Fahnle" wrote:
    >I am assembling a disaster recovery server for an Microsoft SQL Server.

    This
    >server is a Proliant 3000 with one internal DLT 40/80GB and Windows NT 4.0
    >SP6A, SQL Server 7.0 SP2 and Veritas Backup Exec 7.3 Rev 2575.
    >
    >The Production Server is a Proliant 6400R with a library Compaq, with one
    >drive DLT 35/70 and the same software.
    >
    >The problem comes out when I restore a tape of the Production Server in

    the
    >Disaster recovery Server. The SQL Server have 10 databases without
    >considering the system ones (master, temp, etc.)
    >
    >Some of the databases couldn't be restored and the following happens:
    >
    >The job starts in the usual way, it starts to read the tape and when it
    >arrives approximately to 800KB it stays there for hours. The DLT led (tape
    >in use) stays activated permanently.
    >
    >The databases that couldn't be restored don't have anything in particular,
    >and we have another ones that are bigger or smaller, and it could be
    >restored
    >
    >The versions of the DLT firmware are:
    >
    >Production:
    >
    >Compaq 35/70 GB DLT LIB Rev 4.04 Serial mn012281
    >
    >Compaq 35/70 GB LDRV Rev 2150 (V80) Serial CX92054925
    >
    >
    >
    >Disaster Recovery
    >
    >Compaq 40/80 GB DLT DRV Rev 011A (V26) Serial CXA44P0142
    >
    >I could do another tests, which succeeded:
    >
    > 1.. Restoring the same tape from the Production Server (DTL 35/70) to

    the
    >Development Server.
    > 2.. Doing the backup of the databases of the Supporting Server from
    >itself, using the same back up software and the DLT 40/80
    > 3.. Restoring the tape resulting of the 2nd step in the Supporting Server.
    >I think the problem is not in the SQL Server, or in backup software. And

    it
    >seems that the DLT 40/80 is not compatible at all with recorded tapes in

    DLT
    >35/70.
    >
    >Any idea ??
    >
    >
    >
    >
    >



  3. Re: SQL Restore

    I dont founds in BE logs, sql server, event viewer or compaq insight
    manager, only the tape stop.
    I ran sgmon.exe , the last lines are :

    365: 1d2 13:39:12:
    365: SQL Server said OK, opening pipes
    365: 1d2 13:39:12:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-00
    365: 1d2 13:39:13:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-00
    365: 1d2 13:39:13:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-00
    365: 1d2 13:39:14:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-00
    365: 1d2 13:39:14:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-01
    365: 1d2 13:39:14:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-01
    365: 1d2 13:39:15:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-01
    365: 1d2 13:39:15:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-02
    365: 1d2 13:39:15:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-02
    365: 1d2 13:39:16:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-02
    365: 1d2 13:39:16:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-03
    365: 1d2 13:39:16:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-03
    365: 1d2 13:39:17:
    365: Trying to open pipe
    \\.\pipe\BackupExecSqlAgent-{2d5c724d-4a19-11d5-ab3a-0008c74bc161}-03
    365: 1d2 13:39:17:
    365: Pipes open

    The tape read 800kB and stop.
    Gustavo.



    "Gary Higgins" wrote in message
    news:3b03cee1$1@hronntp01....
    >
    > Error messages in BE logs?
    >
    >
    > "Gustavo Fahnle" wrote:
    > >I am assembling a disaster recovery server for an Microsoft SQL Server.

    > This
    > >server is a Proliant 3000 with one internal DLT 40/80GB and Windows NT

    4.0
    > >SP6A, SQL Server 7.0 SP2 and Veritas Backup Exec 7.3 Rev 2575.
    > >
    > >The Production Server is a Proliant 6400R with a library Compaq, with one
    > >drive DLT 35/70 and the same software.
    > >
    > >The problem comes out when I restore a tape of the Production Server in

    > the
    > >Disaster recovery Server. The SQL Server have 10 databases without
    > >considering the system ones (master, temp, etc.)
    > >
    > >Some of the databases couldn't be restored and the following happens:
    > >
    > >The job starts in the usual way, it starts to read the tape and when it
    > >arrives approximately to 800KB it stays there for hours. The DLT led

    (tape
    > >in use) stays activated permanently.
    > >
    > >The databases that couldn't be restored don't have anything in

    particular,
    > >and we have another ones that are bigger or smaller, and it could be
    > >restored
    > >
    > >The versions of the DLT firmware are:
    > >
    > >Production:
    > >
    > >Compaq 35/70 GB DLT LIB Rev 4.04 Serial mn012281
    > >
    > >Compaq 35/70 GB LDRV Rev 2150 (V80) Serial CX92054925
    > >
    > >
    > >
    > >Disaster Recovery
    > >
    > >Compaq 40/80 GB DLT DRV Rev 011A (V26) Serial CXA44P0142
    > >
    > >I could do another tests, which succeeded:
    > >
    > > 1.. Restoring the same tape from the Production Server (DTL 35/70) to

    > the
    > >Development Server.
    > > 2.. Doing the backup of the databases of the Supporting Server from
    > >itself, using the same back up software and the DLT 40/80
    > > 3.. Restoring the tape resulting of the 2nd step in the Supporting

    Server.
    > >I think the problem is not in the SQL Server, or in backup software. And

    > it
    > >seems that the DLT 40/80 is not compatible at all with recorded tapes in

    > DLT
    > >35/70.
    > >
    > >Any idea ??
    > >
    > >
    > >
    > >
    > >

    >




+ Reply to Thread