Hi,

I am also facing the same issue in my production database whenever right click database >> Task >> restore >>database.

Server configuration :

32 GB RAM

64 bit O/S

2 processors

Intel(R) Xeon(R) E5620 @2.40GHZ

service pack 2

SQL server 2008R2

I think this is sufficient information about the server.

In that server over all 750 databases which around 60 GB. And log shipping configure around 700 databases.

Error screenshot attached for ref.

Thanks.