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!
Copying DB from one instance to another
Hot Topic
- Error using pivot transform
- SQL Express and Reporting Services not available until June 2006?
- cursor problem
- Question about data sources formats supported in SQL Server 2005 reporting services
- SQL Server Express 2005 vs. PHP 4.4.1
- spt_datatype_info table in 2005
- Seeking help with "inserted" table
- SQL 2005 Time Sensitive Question
- Storing images in sql server 2005
- How can I get the actual line number from inside flatfile sources for each record?
SQL Server
- Installing Quickstart DB-Samples
- SSIS doesn't start’anymore after SP1 installation
- Display Report Filters in Excel Problem
- Printing reports is very slow.
- Registry to store configuration values ?
- trigger issues
- Can not open SQL Management Studio
- SQL Server 2005 Express remote access?
- Write to Log from Script Task
- SQL DMO Support in SQL Server 2005...
Copying DB from one instance to another
Nathan Jones
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