How to manage max table storage space in case of excess data

Question

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

Vishnu Singh · Answer

Thanks suthish.. I will check and let you know.

Suthish Nair · Answer

https://msdn.microsoft.com/en-us/library/ms143432.aspx

Vishnu Singh · Answer

hi Suthish.. Here 1000 records shows example purpose. Actually I have lac of records in table.

Suthish Nair · Answer

1000 records are nothing also you can auto grow your database. Not sure why such requirement. If above answer not solved your problem then please explain your requirement in more detailed way.

Shashank Patil · Answer

If it has helped you Please accept my answer.

Vishnu Singh · Answer

Thanks Shashank.. I will try and let you know.

Shashank Patil · Answer

I have a solution but it suits your requirement then good. Go by number of rows in log table.. means set it to 1 million or 100 million depends on you. Add a trigger AFTER insert. In the trigger check the number of row in the table if exceeds move all the rows from the log table to remote database table. Truncate the log table. The insert will happen atomatically after the operations. But run in the transaction scope. ------------------------------------------------ If it helps accept the answer.