Hi All,
I am having issue while taking backup of a table (abc). This table has 12+crores records. I need to insert extra 40 lakhs records with the help of import in sqlserver.
So,before inserting 40 lakhs fresh records in the abc table which has already 12+crores records i need to take backup of that abc table and import 40 lakhs records.
While taking backup trans logs space is full and our DBA team has cleared logs. But still i am not able to take backup of that abc table. When i asked DBA team member, he told to take backup of bunches of records not 12+crores records at a time.
Can any one please suggest how to copy bunches of records for backup?
Thanks