August 12, 2009 at 9:07 pm
Hi Everybody,
I had taken full backup after then 15 table have modified
then what database i had taken DIFFIRENTIAL backup or T-log backup
can you please suggest those modifed table have taken backup
Regards
Raj
August 12, 2009 at 9:25 pm
What type of backup you take after modifying 15 tables is up to and part of the decision has to be based on several factors; the recovery model of the database (simple, bulk logged, or full), how much data was changed or modifications to the schema, is the database in a development or production environment, etc.
Based solely on your original post, hard to advise.
August 13, 2009 at 1:01 am
Hi Pettis,
Thank you for your suggestions,
By mistake i had post two time for the reason apologies from my side
my system had hanged once again submited
see scenario
After full database backup i had taken i had modified 15 tables what type backup again i had to taken updated data
(differential, T-log backup i had to taken ) could u plz give suggestion
Regards
Raj
August 13, 2009 at 1:05 am
Hi
Shiv,
Yes you can take a backup all 15 tables which altered .I guess you are working on development environment (Because development guys are keep asking this question ' how to take backup of a particular table')before altering the table design ,create a new database and move those 15 table to there by using SSIS/DTS and then take backup of Cretaed new database , other wise create the copy of your all 15 tables on your current database and rename those tables it begin with 'Backup_table1'.
Thanks and regards.
Ashwin v p
Ashwin VP
CSC India ...
August 13, 2009 at 2:53 am
Hi Aswin,
U should not under stand my question?
Every day i have taken ful ldatabase bakup today also i had taken full database.
After then i had modified (insert,updated)some data now
can any body suggest
What type of backup have to take? (diffrential,T-log backup) in that backup i need modified data also.
Regards
Raj
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply