Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Copy Database Wizard Error

Posted on 2016-11-21
3
Medium Priority
?
60 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
[X]
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
  • 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

721 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