Database operations through SQL: Database Restore ...

If using sql to perform a database restoring , care the sql-codes very well. Any trivial mistake may prevent a successful execution. Cases are listed here based on simple experiments.

  • with operation: MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name'

    If logical file name not correctly set , following error is obtained:

    Logical file 'FILE_NAME' is not part of database 'DATABASE_NAME'. Use RESTORE FILELISTONLY to list the logical file names.

    RESTORE DATABASE is terminating abnormally.

To be continue...

No Comments