Copy database

What would be the easiest way to copy a database from a SQL database to a SQL express databse on my local machine?
LVL 5
thenrichAsked:
Who is Participating?
 
NightmanConnect With a Mentor CTOCommented:
The standard protocol is to "backup" the database. This does not mean the whole server, just the physical database file itself. You then copy it to the SQL Express machine and restore it onto the SQL Express instance.

Here is a detailed article for backing up and restoring databases on SQL2K.

http://technet.microsoft.com/en-us/library/cc966495.aspx
0
 
udaya kumar laligondlaTechnical LeadCommented:
options
1. backup at A and restore at B
2. generate the scipt of the database using (database publishing wizard) and execute the same at destination
3. replication
0
 
thenrichAuthor Commented:
What does that mean to 'backup'? I don't need the whole server only 1 database in the server. The data wold be groing from sql2k to sql express. I think it just might be easist to write a .NET app to do it. I can manage 2 connections and do what I need. I was just wondering if there was some standard protacol I was missing.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.