SQL Server Performance

problem starting sql server service

Discussion in 'Analysis Services/Data Warehousing' started by maxell, Nov 17, 2003.

  1. maxell New Member

    hi
    getting the following error in ms sql server7
    error 17052 : database model cannot be opened, it has been marked as suspected by recovery

    pl. help!!
  2. satya Moderator

    If you've backup for this database, restore from it
    Start SQL Server in single-user mode and Books online specifies to take action for the database error

    First, verify that the database is marked IsShutdown using DATABASEPROPERTY.

    Then, determine the cause of the error by consulting the errorlog, and take action as noted below.

    If one or more data or log files are missing:
    Make the files available and bring the database OFFLINE using ALTER DATABASE.


    Use ALTER DATABASE to bring the database ONLINE
    If insufficient log space:
    Use sp_add_log_file_recover_suspect_db() to add another log file.
    The database is recovered and brought online by this procedure.

    If insufficient data space:
    Use sp_add_data_file_recover_suspect_db() to add another log file.
    The database is recovered and brought online by this procedure.

    If insufficient memory:
    The insufficient memory error can occur when a number of databases are recovered at the same time. Retrying the operation may fix the problem:

    Retry the operation using ALTER DATABASE to bring the database OFFLINE.

    Use ALTER DATABASE to bring the database ONLINE.
    If retrying the operation does not work, consider freeing up memory.



    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page