Restore database, point [device] after [...]. , stuck not response, such as 5-6 minutes will pop up selection interface, what reason be?
Some servers will not
As shown in figure:

CodePudding user response:

Suggestion:
1. Install the latest version of SQL Server Management Studio.
2. Install the SQL Server version of the latest patch.

CodePudding user response:

reference 1/f, started the first response:

advice:
1. Install the latest version of SQL Server Management Studio.
2. Install SQL Server version of the latest patch.

I this machine also is such, the machine even without other server,

CodePudding user response:

Please perform the following on the target server SQL after retry,

 
The exec MSDB. Dbo. Sp_delete_backuphistory @ oldest_date='2020/06/15 00:00:00'; 

CodePudding user response:

The

reference 3 floor started first response:

please retry after on the target server to perform the following SQL,

 
The exec MSDB. Dbo. Sp_delete_backuphistory @ oldest_date='2020/06/15 00:00:00'; 

Historical backup only 10 days, the default directory is not in the SQL backup directory,

CodePudding user response:

Is carried out, please? Whether effective?

CodePudding user response:

If the server has installed anti-virus software, you can stop or turn off the security software to try again, sometimes these security software will produce the impact,

CodePudding user response:

Try upstairs, no, no,,,,

CodePudding user response:

Provide the SSMS version and corresponding version of SQL server information, there may be a help,

The original poster on the restore operation, if you use other backup operation (test), whether there is the problem,

In addition, the server is mount other storage, such as EMC, if any, to provide external storage version, also have certain help,