TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vamsi k
NA
296
46k
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
Reply
Answers (
1
)
Convert STRING DATE TO DATE FORMAT
How to get Highest Sales Person in Month for Monthly Reward