Vamsi k

Vamsi k

  • 1.7k
  • 158
  • 5k

Issue of taking backup of a table whic has 12+crores records

Sep 11 2019 12:47 AM
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 

Answers (1)