How to copy database from server system to localsystem.

Posted by Oswaldlily under Sql Server on 4/25/2013 | Points: 10 | Views : 1846 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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..

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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 Kumaraspcode2009@gmail.com Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

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

Kumaraspcode2009@gmail.com

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

Latest Posts