How to copy database from server system to localsystem.

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

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

Login to post response