0

Yes in Management studio I am trying to restore a backup from another server. So I am doing the following:

  • This is a fresh install of SQL Server 2017 express
  1. Right Click on the Databases Folder and choose restore database.
  2. Then I click on Device and the ... button to the right
  3. I click on add for the file and then this error shows up, I never even get to choose the file so I don't think its a file permission on the file like I have seen elsewhere.

Picture of All The Screens separated with the Error

Show Details..

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

Program Location:

at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.d__1.MoveNext() at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderEx.FillDrives() at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderEx.Initialize() at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.Init(Boolean force) at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.Init() at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreSelectBackupSource.AddFile() at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreSelectBackupSource.buttonAdd_Click(Object sender, EventArgs e)

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

in Program Location I see this: at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.d__1.MoveNext() at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderEx.FillDrives() at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderEx.Initialize() at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.Init(Boolean force) at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.Init() at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreSelectBackupSource.AddFile() at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreSelectBackupSource.buttonAdd_Click(Object sender, EventArgs e)

I noticed it says "at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolderBase.d__1.MoveNext()" I do have a D drive that is a raid array connected to this server is that referencing the d drive by chance or am i just reading that wrong?

Improve this question
8
  • "Show details" might be helpful. Commented May 5, 2021 at 12:45
  • I also found this when i click show details on the message screen... Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) which i'm trying to google now Commented May 5, 2021 at 12:52
  • i have searched and searched and getting no where so if anyone has any suggestions i would greatly appreciate it. Commented May 5, 2021 at 16:02
  • Can you show us each of those dialogs without the other ones covering them? I don't know what might be covered up, but it might give someone an idea. I can't think of what in the restore process would overflow an integer data type. I wouldn't think you have more than 2 billion files in a directory. :-) Commented May 5, 2021 at 22:37
  • 1
    updated the question and it has a link that shows all the windows to give the full picture. Commented May 6, 2021 at 17:55

1 Answer 1

Reset to default
0

brought up a 2019 server, installed sql express 2017 and everything seems to work.. thinking it might be corrupt files on the old server and just not worth my time to figure that out right no.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.