I am using sql server 2008 r2 and I have created a database named testDB. I have a lot of tables with some log tables in this. some tables have contain thousands of records in log table.
So my purpose is that I want to fix the table size of those tables(log tables) and want to move records in other database table placed on another location. So my database has no problem.
Is there any way to make such above steps which I want for my database?
Is there already built any such functionality in sql server?
May be this question repeated but still I have no solution for my issue.
Thanks