Database Recovery but DB is 7GB and log file is almost 3

• Vector

  Valued Member

  Points: 62

  More actions

  October 16, 2021 at 11:55 pm

  #3941221

  I have had a server crash and although I was able to recover the disks and the contents, the SQL database isn't working when I drop the files into the DATA folder and Attach to them. The database immediately goes into Recovery Mode. I tried all the usual commands to get the database up and running but I keep getting errors indicating that there is no disk space available, that the file is in read only mode, and a few other errors. I honestly think that this has to do with the size.

  I moved the log file out of the folder and tried to recover allowing data loss but even that path is throwing errors.

  DBCC CHECKDB (Shop)

  Msg 945, Level 14, State 2, Line 1

  Database 'Shop' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

• Ant-Green

  SSC Guru

  Points: 113544

  More actions

  October 17, 2021 at 6:59 pm

  #3941374

  Restore from backup is your only hope.