• State Not Answered
  • Replies 11 replies
  • Subscribers 97 subscribers
  • Views 6057 views
  • Users 0 members are here
Options
Related

Error on restoring DB on another SQL server

mekindad

When I restored a DB on another SQL server I got the error bellow when I enter new connection string and try to generate new ID

Database error 50000: re-throw in Procedure QBM_PDBQueueInsert_Single, Line 7
Database error 50000: re-throw in Procedure QBM_PDBQueueInsert_Bulk, Line 14
Database error 50000: re-throw in Procedure QBM_PDBQueueInsert_Int, Line 71
Database error 3930: detected in (SRV=HSE-SQL4, DB=OneIM21) Procedure QBM_PDBQueueInsert_Int, Line 47
Database error 3930: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.

SQL user is ok and also viadmin has correct password .... so any ideas?

Thank you 

Parents
  • 0

    Double-check to following in SQL Server Management Studio

    Select OneIM21 Database properties
    Select Files and check if Owner is same account as DB connection SQL account.

    Security > Logins: DB connection SQL account
    User Mapping Database: OneIM21, User: dbo, Default Schema: dbo

    Server roles: DB connection SQL account
    Same as on original SQL server.

    Shrink the log: Tasks, Shrink, Files

Reply
  • 0

    Double-check to following in SQL Server Management Studio

    Select OneIM21 Database properties
    Select Files and check if Owner is same account as DB connection SQL account.

    Security > Logins: DB connection SQL account
    User Mapping Database: OneIM21, User: dbo, Default Schema: dbo

    Server roles: DB connection SQL account
    Same as on original SQL server.

    Shrink the log: Tasks, Shrink, Files

Children
No Data