Copying a database from SQL Server 2000 to SQL Server 2005
Home > IT Answers > SQL Server > Copying a database from SQL Server 2000 to SQ...
SQL Server Ask the Experts
2445 pts.
0
Q:
Copying a database from SQL Server 2000 to SQL Server 2005
SQL Server 2000, SQL Server 2005, SQL Server database
I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path '\SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLDatactyis_before_migrate_data.mdf' is denied.”). Do you have any suggestions on how to go ahead?
ASKED: Aug 11 2008  4:03 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Where are you putting in the path to the source database? If you are connecting to a SQL Server instance you shouldn't need to put in a source path, only the source SQL Server, and the database name. Same goes for the destination. If the destination doesn't exist it will ask you for a path, but that will be a path local to the destination server, not a UNC path.
Last Answered: Aug 11 2008  8:26 PM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46810 pts.  |   Aug 11 2008  8:27PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0