Forum Discussion

wsutton's avatar
wsutton
Level 3
10 years ago

Restoring SQL Server 2008 database to SQL Server 2012

Environment is NetBackup 7.6.0.3 (Linux master and media servers, the client in this case is running Windows 2012). Someone wants me to restore one of our SQL Server 2008 R2 databases to a test SQ...
7.6
Agent for Microsoft SQL Server
Backup and Recovery
NetBackup
Restore
Windows Server (2003-2008)
  • Abesama's avatar
    Abesama
    10 years ago

    Hi,

    It could be simply from your log-sanitizing but I wanted to point out that I see this at the beginning of your dbclient log.

    move 'TESTDB' to 'E:\LDF\TESTDB.ldf', move 'TESTDB' to 'F:\LDF\TESTDB.mdf',

    Usually, it's supposed to say move database_log to ldf, while your log is stating that the same "TESTDB" is being moved to both of ldf and mdf.

    If your move script has lines as

    MOVE "TESTDB"
    TO "F:\LDF\TESTDB.mdf"
    MOVE "TESTDB"
    TO "E:\LDF\TESTDB.ldf"

    then modify the lines to read,

    MOVE "TESTDB"
    TO "F:\LDF\TESTDB.mdf"
    MOVE "TESTDB_log"
    TO "E:\LDF\TESTDB.ldf"

    Also we could look at the full restore dbclient logs to find out if there are any of <8> or <16> lines which would tell us more about the higher severity conditions.

    As you know, NetBackup log files say lots of "not matching" "rejected" "not found" lines and they are mostly just part of cross-checking or routine verification steps, not necessarily being the root cause of the failure.

    Hope this helps.

    A

Abesama's avatar
Abesama
Level 6
10 years ago

Hi,

It could be simply from your log-sanitizing but I wanted to point out that I see this at the beginning of your dbclient log.

move 'TESTDB' to 'E:\LDF\TESTDB.ldf', move 'TESTDB' to 'F:\LDF\TESTDB.mdf',

Usually, it's supposed to say move database_log to ldf, while your log is stating that the same "TESTDB" is being moved to both of ldf and mdf.

If your move script has lines as

MOVE "TESTDB"
TO "F:\LDF\TESTDB.mdf"
MOVE "TESTDB"
TO "E:\LDF\TESTDB.ldf"

then modify the lines to read,

MOVE "TESTDB"
TO "F:\LDF\TESTDB.mdf"
MOVE "TESTDB_log"
TO "E:\LDF\TESTDB.ldf"

Also we could look at the full restore dbclient logs to find out if there are any of <8> or <16> lines which would tell us more about the higher severity conditions.

As you know, NetBackup log files say lots of "not matching" "rejected" "not found" lines and they are mostly just part of cross-checking or routine verification steps, not necessarily being the root cause of the failure.

Hope this helps.

A