Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Has anybody else had this issue? I am running SQL Server 2008 Express and am attempting to restore a database from file. When I click the 'Add' button to choose my backup file SQL Server stops responding. I tried running in Vista SP2 compatibility mode, but that did not help.

share|improve this question
Not programming, and should not be using beta products. Dont expect support. – leppie May 18 '09 at 12:16
True, I thought since it was at least related to programming that this would be a good place to try. – AgileJon May 18 '09 at 12:20
@leppie: RC is not beta. RC means if we don't find any horrible bugs, this is what's going to ship. – John Saunders May 18 '09 at 12:27
As I re-read that... why shouldn't I be using beta products? Isn't that the point? – AgileJon May 18 '09 at 20:14

You need SQL Server 2008 SP1

share|improve this answer
This could be the solution! – abmv May 18 '09 at 13:21
Yep, that was it! – AgileJon May 19 '09 at 3:17
  1. Check if your drive D: or C: or whatever has compression enabled if so uncheck and wait and repeat.
  2. Check if backup is compatible for
    1. (check net for more on this).
  3. Check if works on different environments...
share|improve this answer
I do not have compression enabled on the C drive. At this point I just want to be able to select the backup file (I'm sure it is compatible with sql server 2008)... but I can't get that far. – AgileJon May 18 '09 at 12:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.