Attach and Detach

Last Post 11 Jan 2004 10:53 PM by satya. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mkeller
New Member
New Member

--
08 Jan 2004 04:33 AM
I have new Servers . Win2k and SQL2k. I can restore my db's and change the path to accomadate the new path.

If I restore my Master I loose connection to sql. to fake it out I copy the orignal data folder with the mdf and ldf to the proper directory Path and that will bring back SQL,


So the Question is I can detach by highlighting the master right click and click on detach.


How do I attach with the new Path. ( ex: OLD pathe d:\program files\MSSQL7\Data
New Path is d:\program files\Microsoft SQL Server\MSSQL\DATA)?


Note: Old server was upgraded to sql2k and the new box is also sql2k.


thank you for your support
mkeller
New Member
New Member

--
08 Jan 2004 06:19 AM
Where or how would you do that?
satya
New Member
New Member

--
11 Jan 2004 10:53 PM
Refer to this KBA about dealing with the issue.
You are not authorized to post a reply.

Acceptable Use Policy