Closed. This question does not meet Stack Overflow guidelines . It is not currently accepting answers.

This question does not appear to be about programming within the scope defined in the help center .

Closed 16 hours ago.
Improve this question

When I try to restore a database of 35 gb, on a server with windows 2008 R2, SQL 2008R2 database gives me the following errors:

The curious thing is that it allows me to restore it on another computer, with less resources and computing capacity.

I tried the following:

To try to recover the situation we have done the following:

1. Validate the performance of the server at certain hours and times of the day taking into account possible peaks of writing and reading that may occur throughout the day.
2. Monitor the behavior of all the resources of the server, since when trying to restore files from other years in particular the server is inhibited and restarts.

At the database level

• The backup was deleted with problems, and repeated attempts were made to restore, but no progress was made.
• An attempt was made to partition the DB so that the information is visible to the users, but it did not finish properly either.
• Restore tests were performed on other computers to determine the integrity of the data and possible backup errors, ending successfully.
• RESTORE DATABASE *database_name* { FILE **=**_logical_file_name_ | FILEGROUP **=**_logical_filegroup_name_ }[ **,**...*n* ] WITH RECOVERY