How to copy and paste a db

Posted Date: 04 Nov 2009 Posted By: G.Hemadribabu Member Level: Gold Points: 1 Responses: 3

hi ,

I have an SQL DB test in one server.

I had created an other server called test1

I have to copy test DB to test1 DB.

pls telme the meathods,

NOTE: - after copying , there source and destination DBs should have datas

________________________

I recommended

1. restoring the earlier backup in the test DB

Any other meathod pls let me know

urgent

thank you
hemadribabu

Responses

Author: Nikhil Gaur 04 Nov 2009

Member Level: Diamond

Rating:

Points: 2

look at the following links

http://vyaskn.tripod.com/moving_sql_server.htm

http://www.sqlservercurry.com/2008/03/copy-table-from-one-database-to-another.html

Join this campus group
http://www.dotnetspider.com/sites/637/-ecb-aspdotnet.aspx

Thanks & Regards
NIks
My Software and Web Development Experience

Author: Abhisek Panda 04 Nov 2009

Member Level: Gold

Rating:

Points: 2

You can simply copy the .MDF and .LDF files of your DB to another server. After copying restore it using the enterprise manager of SQL Server.

Thanks And Regards,
Abhisek Panda
Be Happy And Make Others Happy.
Go Green and Save Your Future.

Author: sriram 23 Nov 2009

Member Level: Bronze

Rating:

Points: 2

u can to Import/Export option in Enterprise Manager in sql server

Post Reply

You must Sign In to post a response.

	Next : View
	Previous : How to configure an reindexing job in sql server 2000
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use