Sunday, March 11, 2012

Copying DB from one instance to another

Hi,

I want to copy the "Example" database of SQL 2000(default instance) into MSDE (named instance).

Both are installed on the same machine.

HOw to do this?

Thank You!

Use the copy database wizard. The SQL Server Tools General forum is probably the best place to ask about that http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1 and it is covered in Books Online http://msdn2.microsoft.com/en-us/library/ms188664.aspx

Donald Farmer

No comments:

Post a Comment