I have a database and its size is 70MB also the log file have a size of 30MB. I am using this db for one of my application and going to insert data frequently and it will grow big very fast.
I dont want to loose the data going into the SQL DB, but at the same time as data is going to grow with time i need to take care of the size.
Is there any way in sql server 2005 I can store my data somewhere and also free up some space. I will need to pull out this information on front end later on.
All I want is I guess a way to capture the historic data or the sql data somewhere in the history which dont really occupies the space in SQL server and I can also pull out that data on front end using vb.net.
Also please suggest me any other ways I can handle this in this particular case.