Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Copy Database Wizard Error

Posted on 2016-11-21
3
Medium Priority
?
64 Views
Last Modified: 2016-12-28
Hi Guys,

I am trying to copy my local database from my local machine to remote SQL Server . However i am not sure which file to put in
File Share On Source Server

Open in new window


The name of my database is LocalTest and i get the attached message when i put the name LocalTest under File share on source server

Error
any Ideas?
0
Comment
Question by:shah36
  • 2
3 Comments
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 41895840
Try to follow this my article and let me know if you had issues.
0
 

Author Closing Comment

by:shah36
ID: 41896087
Thank you however it did not explain the file share but i have not used the detach and attach database so it worked
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41896098
I can't see from the picture the full path for the File Share. It should be something like: "\\server_name\C$\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data".
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

879 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