March 29, 2010 at 9:07 am
I am working in E discovery project databases. We have nearly 40-50 GB size databases and we want to take backup of client work product mean what ever work they done and move this on remote side for backup purpose.
For that we are planning to create application which periodically read records from client work product related tables and store in csv/xml files and move this files daily on remote location.
for tracking this reading/restoring data we are thinking to add for GUID (unique identifier timesta column for these tables. and base on this column we can track next records for
reading. We are planning to run this application as job for each databases and move files.
Please give your advise for this.
March 30, 2010 at 10:07 am
The GUID may not help, except to insure that you have a unique ID for each record.
The Timestamp field is what you'd need.
Sounds like you're on the right track. Keep going!
Rob Schripsema
Propack, Inc.
March 30, 2010 at 10:07 am
[Ignore this post -- how does one delete an accidental double post?]
Rob Schripsema
Propack, Inc.
April 2, 2010 at 4:30 am
Is it advisable to use this method for backup purpose ? Is there any way that we can backup data only selectd tables and only last uldated/inserted/deleted periodcially ?
April 2, 2010 at 9:48 am
You can't use native MS SQL Server tools to do selective backups - you back up the whole database or nothing. (OK, you can back up just the transaction logs, but that's a different issue).
There may be third party tools that allow you to do a more selective backup. I'm not sure what your options are there.
However, you can use the method you're talking about (or some variation on it) to copy only certain tables, or only certain records from certain tables, to a separate database, and then just back up THAT database. The possibilities and variations on that theme are numerous -- all depends on what you're trying to accomplish.
Rob Schripsema
Propack, Inc.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply