I am using SQL Server 2008 R2. I have created a database named testDB. I have a lot of tables with some log tables in. Some log tables contain over 100k records.
I want to fix the size of those log tables, and want to move records into another database table in 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?