Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Question Unanswered: Database dump of 11.5 Adaptive Server , when restored on the following Targer 12.0 se

    Problem :-


    Database dump of 11.5 Adapt
    ive Server , when restored on the following Targer 12.0 server....Load is successful , but error comes when online database is done.

    ================================================== =
    Source Server :- Adaptive Server Enterprise/11.5.1/P/Sun_svr4/OS 5.5.1/SWR 8070 rollup/opt

    The above server is from which dump is taken...

    ================================================== ====

    Target Server :-
    Adaptive Server Enterprise/12.0/P/Sun_svr4/OS 5.6/1576/32bit/FBO/Thu Nov 4 03:51:52 1999

    The above server is on which database is restored.

    ================================================== =======
    Error details...



    1> online database cts_ipa_depo
    2> go
    Database 'cts_ipa_depo' appears to be at an older revision than the present
    installation; SQL Server will assess it, and upgrade it as required.
    Database 'cts_ipa_depo': beginning upgrade step: adding column (table
    sysindexes, column fill_factor) [ID 1120]
    Database 'cts_ipa_depo': beginning upgrade step: adding column (table
    sysindexes, column res_page_gap) [ID 1121]
    Database 'cts_ipa_depo': beginning upgrade step: adding column (table
    sysindexes, column exp_rowsize) [ID 1122]
    Database 'cts_ipa_depo': beginning upgrade step: executing SQL statement (update
    sysindexes set fill_factor=0) [ID 1123]
    (601 rows affected)
    (607 rows affected)
    (333 rows affected)
    Database 'cts_ipa_depo': beginning upgrade step: creating table (table
    systabstats) [ID 1124]
    Database 'cts_ipa_depo': beginning upgrade step: creating table (table
    sysstatistics) [ID 1125]
    Database 'cts_ipa_depo': beginning upgrade step: Initialize systabstats with
    valid statistics [ID 1126]
    Database 'cts_ipa_depo': beginning upgrade step: Begin upgrade of distribution
    pages [ID 1127]
    The SQL Server is terminating this process.

    ================================================== ======

  2. #2
    Join Date
    Jan 2003
    Location
    France - Nancy
    Posts
    26
    Hi,

    I think that you must have a stack trace in the errorlog corresponding with that : "The SQL Server is terminating this process."

    True or not ?

    Carbone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •