I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible version of the AdventureWorks database to make sure it was working. To do so, I right clicked on my main database server in the explorer window > Restore Database
and attempted to mount a .bak file using Source
> Device
> Add
. I downloaded the AdVentureWorks .bak file from http://msftdbprodsamples.codeplex.com/releases/view/55330 into my user directory, however when I try to access this directory, it comes up blank:
I'm currently authenticated using my Microsoft account (i.e. I logged in using my Microsoft account during my Win8 installation and setup my user profile accordingly).
My question is - shouldn't I be able to see my user directory structure? If not, is there a new convention for Win8 that I'm not aware of?
Incidentally, I was able to restore my database by copying the file to the C:\ root and restoring from there.
C:\Users\aaron_000\Downloads
from Windows Explorer. It looks to be a bug in SSMS to me.