Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Moving SQL database from Win8 machine to file server.  cant get express or studio to install

Posted on 2015-01-13
14
23 Views
Last Modified: 2015-06-30
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.
0
Comment
Question by:Knightsman
  • 6
  • 2
  • 2
  • +2
14 Comments
 

Expert Comment

by:IDMA
ID: 40548184
Do a backup of the DB in Win8 and the import it into the server.
Typically the backup location is: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup

Right-click on DB -> Tasks -> Backup

On the Backup to: select Disk -> Add (button) -> File name should be the above location (C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\yourdatabase.bak)

Make sure you type the .bak

On the server, pretty much follow the same process but choose restore instead of backup.

I hope this helps
0
 
LVL 7

Author Comment

by:Knightsman
ID: 40548190
I went to that folder location:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup

no backups seem to be in that folder.  I do however see that database in "data" (as it should be)
0
 

Expert Comment

by:IDMA
ID: 40548194
You do the backup/restore procedure with SQL Management Studio.  I missed this part.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 77

Expert Comment

by:arnold
ID: 40548206
Which version of sql server are you trying to install and on what system?  You may need to install the 3.5NETFX feature.

You need to download and install the sql server management suite express.
From: http://www.microsoft.com/en-us/download/details.aspx?id=22985
Where are you moving the database to?
0
 
LVL 7

Author Comment

by:Knightsman
ID: 40548224
I have tried to install it, it fails to run, I get two compatibility alerts and then it fails to run the install.  I mentioned that in my OP.

It appears the workstation has of SQL server 2008 R2.
0
 
LVL 77

Expert Comment

by:arnold
ID: 40548274
What compatibility issues?  

Often, the errors/compatibility issues provide a link describing how to resolve it.
0
 
LVL 7

Author Comment

by:Knightsman
ID: 40549579
0
 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 40549978
what it means is that before you can use the product it must be updated with the applicable service pack. So you install the product with the run without getting help, and then update the product with windows update.
0
 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 40550164
what it means is that before you can use the product it must be updated with the applicable service pack. So you install the product with the run without getting help, and then update the product with windows update.
0
 
LVL 7

Author Comment

by:Knightsman
ID: 40550443
But server 2008 is already running on the system.  All updates are already in place.  The problem is the management console (studio) I am used to seeing on an actual server is not there.  

The only options that come are the ones posted above.
0
 
LVL 7

Author Comment

by:Knightsman
ID: 40550445
I have reinstalled SQL server,
I have downloaded and installed the followign:
SQL Server 2012 management Studio
SQL Server 2012 express
SQL Server 2008 management Studio
SQL Server 2008 express

but these options do not show up as an application.  I just installed this same thing on the file server it managment studio is there, but its not on this win8 machine.  It just doesnt make any sense.  Ultimately, I need to figure out a way to just transfer the database over to the new server.
0
 
LVL 7

Accepted Solution

by:
Knightsman earned 0 total points
ID: 40550448
I finally got it.  I found an older version of SQL Server management studio 2008 from file hippo and it worked.  

This is why I hate computers...
0
 
LVL 34

Expert Comment

by:Seth Simmons
ID: 40859103
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question