How to copy database from server system to localsystem.

Posted by Oswaldlily under Sql Server on 4/25/2013 | Points: 10 | Views : 697 | 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..


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


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

Mark as Answer if its helpful to you
EmailId :

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

Login to post response