Error opening a database in SQL Server 2008

0

I do not know what the following error should be:

USE BD_INVENTARIO
GO

Mens. 945, Nivel 14, Estado 2, Línea 1
No se puede abrir la base de datos 'BD_INVENTARIO', porque no es posible tener acceso a archivos, o la memoria o el espacio en disco son insuficientes. Consulte el registro de errores de SQL Server.

And in the object browser I can not deploy this database (1 and 2) :

And when I put in properties, I get the following:

On the internet I get some queries to seemingly solve a problem of users not found in databases from other servers using the command "USE" , but as you can see I can not use that command.

Please some guide to solve the incident.

Thank you very much.

    
asked by Fran.J 17.04.2018 в 19:10
source

1 answer

0

This error can be solved in 4 ways that are the following:

  • If possible, add more hard disk space by deleting unnecessary files from the hard drive or adding a new larger hard drive.

  • Verify if the database is set to grow automatically.

  • Verify if the account trying to access the database has enough permission to perform the operation.

  • Ensure that the .mdf and .ldf files are not marked as read-only at the file system level of the operating system.

  • You can read more about this error in this link Sql server

        
    answered by 18.04.2018 в 18:32