How to copy database from server system to localsystem.

Posted by Oswaldlily under Sql Server on 4/25/2013 | Points: 10 | Views : 706 | Status : [Member] | Replies : 1
How to copy database from server system(SQL 2005) to local system(sql 2008).

I tried import and export data where oly my table got copied..

Triggers and storedprocedure,functions were not copied..




Responses

Posted by: Jayakumars on: 4/25/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

take backup and Restored then You will got whole objects your db.
check this urls

http://msdn.microsoft.com/en-IN/library/ms177429(v=sql.100).aspx
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/32a67469-0636-4ded-923f-2e257f7e68e1/
http://msdn.microsoft.com/en-us/library/ms177429.aspx
http://msdn.microsoft.com/en-IN/library/ms187048.aspx



Mark as Answer if its helpful to you

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response