By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

SQL Server Migrating from XP to Vista - How to copy databases over

Expert 100+
P: 211
Anyone know the best way to attach a database that is created with SQL Server Studio as a database file in Visual Studio? I created a database with Studio and now decided to copy it to local folder and attach it to VS but it doesn't allow me to do so.
Error: The database with the same name exist, or specified file can not be opened or it is located on UNC share
I know the problem comes from different Server name
eg: my old server name is XXX\SQLEXPRESS
my new server name is YYY\SQLEXPRESS
Because I attach database into another pc not the pc that I created the database. And one more thing is that I used Windows Authentication in the old server.
Should I detach database within Studio and copy it over will help???
Jun 20 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Backup your DB from your old pc and restore it on your new pc

-- CK
Jun 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.