Sql

Attach a sql database running SQL Server on EC2

Here are the steps to attach a SQL db  Copy the database data and log files to /var/opt/mssql/data Run chmod 777 for the data and log file Connect to Sql Server using sqlcmd command line: sq [...]

How To Repair A Suspect Database In MSSQL

Possible Causes The database could have become corrupted. There is not enough space available for the SQL Server to recover the database during startup. The database cannot be opened due to [...]