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

Vishnu Singh

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishnu Singh11y ago
Thanks suthish.. I will check and let you know.
0
Suthish Nair11y ago
https://msdn.microsoft.com/en-us/library/ms143432.aspx
0
Vishnu Singh11y ago
hi Suthish.. Here 1000 records shows example purpose. Actually I have lac of records in table.
0
Suthish Nair11y ago
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.
0
Shashank Patil11y ago
If it has helped you, Please accept my answer.
0
Vishnu Singh11y ago
Thanks Shashank.. I will try and let you know.
0
Shashank Patil11y ago
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.
0