locked
databases in company RRS feed

  • Question

  • User378425653 posted

    ​Our company uses SQL Server 2008 R2. All the databases are connected. Several days ago something happened with one of the databases. It stopped opening. We don't know how to be.

    Monday, August 28, 2017 2:38 PM

All replies

  • User753101303 posted

    Hi,

    Depending on the issue you'll perhaps have better support in specialized forums found at https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

    As always rather than focusing on what doesn't happen (ie the "db stopped opening") focus first on what happens. What is the db status? Try to check the SQL Server error log in which you may find a message that would help to better understand the root cause. See https://docs.microsoft.com/en-us/sql/relational-databases/performance/view-the-sql-server-error-log-sql-server-management-studio

    Monday, August 28, 2017 3:54 PM
  • User364663285 posted

    ​Our company uses SQL Server 2008 R2. All the databases are connected. Several days ago something happened with one of the databases. It stopped opening. We don't know how to be.

    1. Go to server

    2. Check if relevant Database services are up

    Tuesday, August 29, 2017 5:25 AM
  • User347430248 posted

    Hi EstelleDeCle...,

    I agree with the suggestion given by the other community member regarding checking the service is running or not.

    below is the detailed steps you may try to follow.

    Click Start, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager

    If you do not have these entries on the Start menu,  SQL Server is not correctly installed. Run Setup to install the  SQL Server Database Engine. 

    • In SQL Server Configuration Manager, on the left pane, click SQL Server Services. The right pane lists several services that are related to  SQL Server. If the  Database Engine is installed, the  Database Engine service is listed as SQL Server (MSSQLSERVER) if it is the default instance; or SQL Server (<instance_name>), if the  Database Engine is installed as a named instance. Unless the instance name is changed,  SQL Server Express installs as a named instance with the name SQLEXPRESS. A green triangle icon indicates that the  Database Engine is running. A red square icon indicates that the  Database Engine is stopped. 

    • To start the  Database Engine, in the right pane, right-click the  Database Engine, and then click Start.

    Reference:

    Determine Whether the Database Engine Is Installed and Started

    Regards

    Deepak

    Tuesday, August 29, 2017 6:55 AM
  • User-1628915422 posted

    ​Our company uses SQL Server 2008 R2. All the databases are connected. Several days ago something happened with one of the databases. It stopped opening. We don't know how to be.

    If you can’t open or repair .mdf via any method, in such case was created special instrument like mssql database repair

    Here are represented the models of sql recovery - https://www.mssqltips.com/sqlservertutorial/2/sql-server-recovery-models/

    It is the address of the guide below: https://www.mssqltips.com/sqlservertutorial/112/recovering-a-database-that-is-in-the-restoring-state/

    Restore full backup WITH RECOVERY
    As mentioned above this option is the default, but you can specify as follows.
    RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
    WITH RECOVERY
    GO

    Recover a database that is in the "restoring" state
    The following command will take a database that is in the "restoring" state and make it available for end users.
    RESTORE DATABASE AdventureWorks WITH RECOVERY
    GO

    Restore multiple backups using WITH RECOVERY for last backup
    The first restore uses the NORECOVERY option so additional restores can be done.  The second command restores the transaction log and then brings the database online for end user use.
    RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
    WITH NORECOVERY
    GO
    RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN'
    WITH RECOVERY
    GO

    Tuesday, August 29, 2017 1:22 PM