Copy database from one database to another with minimum data

Posted by Kirthiga under Sql Server on 5/3/2013 | Points: 10 | Views : 1761 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Im having a database with 500 GB. I have to create a sample database from my original database with the size of 10 GB. In my sample database i need sample of 1000 records from each table from the original database since original database having lakhs of records. Original database tables have constraints and Index i want the same in my sample database tables.

How to create a sample database?

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Santhi on: 5/3/2013 [Member] Starter | Points: 25

0	HI Refer this link: This may help you. http://technet.microsoft.com/en-us/library/ms188664.aspx Thanks & Regards, Santhi .V Kirthiga, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts