mode database> suspect

I do not know whether to activate the operating system license, have enabled some options that have blocked the databases.

The following is a structured approach to handle a suspect database. Don't rush to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS

Recommended actions for corrupt or suspect databases

Check SQL error log first, Post your finding from SQL error log

this is errorLOG
ERRORLOG

i am trying this

DBCC CHECKDB('ION_Data') WITH NO_INFOMSGS

but i have this error
Msg 926, Level 14, State 3, Line 1
Database 'ION_Data' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

i am trying this

ALTER DATABASE ION_Data SET EMERGENCY

Msg 5011, Level 14, State 9, Line 1
User does not have permission to alter database 'ION_Data', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

i try this

ALTER DATABASE ION_Data SET EMERGENCY

Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 9001, Level 21, State 4, Line 1
The log for database 'ION_Data' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

NOW

i have this error
ALTER DATABASE ION_Data SET EMERGENCY

Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

this is the version of sql server
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)   Jun 28 2012 08:36:30   Copyright (c) Microsoft Corporation  Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

More than 60 hours passed. How things looks today?

I this again

ALTER DATABASE ION_SystemLog SET EMERGENCY

Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 9001, Level 21, State 4, Line 1
The log for database 'ION_SystemLog' is not available. Check the event log for related error messages. Resolve any errors and restart the database.


the database is supect mode

i can see
view attached
files-log.png

One thing is what you can see, another thing is what the SQL Server is expecting.
Can you check by the logs if those files are the one SQL Server is expecting?
By the way, why do you have 2 data and 2 transaction log files? And they have different dates.

One thing is what you can see, another thing is what the SQL Server is expecting. I agree.

Can you check by the logs if Those files are the one SQL Server is expecting?
As I do?

By the way, why do you have 2 data and 2 transaction log files? And They Have different dates. These two databases are in supect way, I have another in the same instance as the ONLINE

name      state_desc
master      ONLINE
tempdb      ONLINE
model      ONLINE
msdb      ONLINE
ION_Data      SUSPECT
ION_Network      ONLINE
ION_SystemLog      SUSPECT
ApplicationModules      ONLINE

it runs successfully but does not return records

Can you detach the database?

i can not

TITLE: Microsoft SQL Server Management Studio
------------------------------

Detach database failed for Server 'SISGESTENERGY\ION'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Detach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot detach a suspect or recovery pending database. It must be repaired or dropped. (Microsoft SQL Server, Error: 3707)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=3707&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

more detail please, about
change the data and transaction log filenames
files-log-02.png

i try this (other name database

CREATE DATABASE ION_SystemLog02
    ON PRIMARY (FILENAME = 'C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Database\SystemLog\ION_SystemLog_Data.mdf')
    FOR ATTACH;

 but i have this error
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Database\SystemLog\ION_SystemLog_Data.mdf". Operating system error 2: "2(failed to retrieve text for this error. Reason: 15105)".

Check if the files is not marked as read only.
You should also add the .ldf file.

Finally delete both BD and restore from my last backup. Thank you very much for your support.