Now that I have solved the problem of sort ID, I can proceed with my restore. However, I do have a new message now. It says:
[SQL Server] Data on dump will not fit into current database. Need 300 Mbyte database.
That backup is about 100k. What wouldn't I need to increase the size of my database to 300 Mbyte just to be able to restore 100k?
Also, in our test environment, we don't have a production environment thus not having the same disk storage. Isn't this a problem?
Our test environment is having a database of 10 MB which is more than we need. But, we received a backup from a copy of the production environment we are trying to implement where the database size is 300 MB.