I have to restore a backup of a database SQL Server 2014
I am trying to restore it but it doesn't load the database. The .bak weighs 11GB and when I load the .bak shows that no backup copies was selected to restore it and don't appear nothing more and don't appear backup copies
I try to make a new database, make a table with some data and make a .bak of this and it restore me well. So, I don't know...
Why can be?
I am using SQL Server 2014 Management Studio
Thanks in advance
If you are getting that message, then you are trying to restore a database to a SQL Server Express instance. SQL Server Express is a free version of SQL Server that doesn't have many features that paid version have. For example, it doesn't have SQL Agent. Another limitation, which is the one you are experiencing, is that you can only have databases up to 10GB in size. See more in the documentation attached.
If you aren't working with production data, then you can use SQL Server Developer and restore your database