passion420
asked on
SQL DB Data
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.
Thanks !!!
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.
Thanks !!!
ASKER
but if the data will be online then it will increase the size of my database.. how can i handle the increase in size of my database??? also is there any alert or something in the sql server where it can warn me that database is about to have its open space finished?? How about log file can i retrieve data from log files in sql server using my front end, may be storing the data in log??
Sorry too many questions at once :P
Sorry too many questions at once :P
Hi,
Increase in DB size shouldn't be a problem if your queries are written in correct manner and db is in good structure.
you can run sp_helpdb on master db to see the size of your db and you can create another schema in your database to store old data if you want to...
Increase in DB size shouldn't be a problem if your queries are written in correct manner and db is in good structure.
you can run sp_helpdb on master db to see the size of your db and you can create another schema in your database to store old data if you want to...
ASKER
Hi Aanvik
How can I create another schema in the database?? Can you provide more info on that??
Creating another schema in db does not occupy the space??
How can I create another schema in the database?? Can you provide more info on that??
Creating another schema in db does not occupy the space??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you need data to be extracted from a front-end application in vb.net, the data has to be available and online in a SQL Server database..