Solved

Copy Database Wizard Error

Posted on 2016-11-21
3
35 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 47

Accepted Solution

by:
Vitor Montalvão earned 500 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 47

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Some sers suddenly getting error popup msg 28 89
VBScript Write Column Headers 3 38
sql select record as one long string 21 24
SQL Syntax: How to force case sensitive query? 2 31
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.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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

821 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