Thanks for guidance. If you could share the file, I appreciate it Regards
On Wed, Apr 14, 2010 at 11:27 AM, Rob Richardson <rob.richard...@rad-con.com > wrote: > I often have to create test copies of a production database. The > database has several large tables that contain historical data that is not > needed for our system to run, and just wastes time doing backups and > restores. I created two batch files, one for backing up and the other for > restoring. The backup file begins with a command to backup the scheme of > the database, and then there is a series of commands to backup the tables I > need, once command per table. The restore file works the same way. I think > a similar idea would help you. You could trim the batch files (or at least > the restore batch file) to give you only the tables you need. > > If you want, I'd be happy to E-mail you the batch files. > > RobR > >
