Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlvijay
Starting Member
16 Posts |
 Posted - 2009-05-21 : 06:43:00
|
| Hi Everybody I am new sqlserver.In my production database we using sql server 2005.Two months before my database SIZE is 11GB.within two months database size is gradually increased to 25GB.Hence the size differs daily by decreasing oneday and another day increasing eg: one day 25GB and another day 23GB and so on Can I have the initial capacity of MY databases set to 50GB and as and when it reaches 90% of the total size, can I auto-increment the size by 15%?my database data file auto growth has been set to 35%. Is it sufficient enough for the database to function properly?how can we calculate present database initial capacity? Is it possible to setup some initial capacity?and how can we set initial capacity?please onsite workers reported me the database Usage is very high . It is showing the red mark by using some tool for sql server . Can we set it something to 50G?please share your ideas and suggest the solution Thanks in Advance Vijay.S |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-05-21 : 06:57:05
|
| What Recovery Model have you selected?If you don't need point in time recovery you should probably be using Simple recovery model. (I think the default is FULL)Otherwise your database are going to grow and grow unless you perform log backups regularlyCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
sqlvijay
Starting Member
16 Posts |
Posted - 2009-05-29 : 21:56:06
|
| Hi Everybody Acutually we have implemented Transactional log backup every four hours a day,differential backup every eight hours a day and a full backup once per day plan in the server for the particular database.After implementing this my database size is goes arround 60gb from 30gb within one day. After that I have shrinked the database.Then i got the old database size 30gb.now the database size is 30gb and space available is 1gb.Is it advisable to have above plan?The tool always showing full database capacity.How come i can avoid full database capacity (i.e) redmark in database capacity monitoring tool Also suggest how can i avoid the dataloss from database. please share your ideas.Thanks in Advance Vijay.s |
|
|
|
|
|
|
Initial capacity of database in sql server 2005