Moving SQL database from Win8 machine to file server. cant get express or studio to install
Posted on 2015-01-13
I have a windows 8 machine. Client has been running a program that is using SQL Server 2008 R2. I have never moved a db from windows 8.
The problem, I cannot install SQl server express or studio, it yells compatibility issues, and will not fully install without errors. This is a fairly new install of win 8.
The only options I have are:
Import and export data
SQL Server Configuration manager
SQL Server error and usage
SQL Server installation center
I have gone through these and I do not seem to know how to actually backup the database. I figured the logical option was to use the import and export, but it doesn't seem to give me an option to export it specifically to a location to find it. Mostly, i have just never messed with it, ive read the MDSN walk through and i'm a bit lost. Once I have the DB i can get it into the new server.
Any help would be greatly appreciated.