All Questions
Tagged with database-size transaction-log
6 questions
0
votes
1
answer
466
views
How to predict database size?
One of requirments for database which I am building is to predict database size to prepare hardware for production environment. Aapplication has 2 main tables wchich are partitioned. Tables are in 8 ...
- 119
0
votes
2
answers
1k
views
Maximum size transaction log and impact
I was doing some research on what the recommended maximum size for the transaction log, but I cannot find any substantiate or documented answer. I learned that a log size of about 25 - 50 percent of ...
- 529
2
votes
2
answers
1k
views
Why is my SQL Server database file so large?
I have a relatively simple database that is over 300MB on disk. When I look at the table data it adds up to just over 5MB. Please see the screenshot below:
This screenshot can also be seen here.
If ...
- 129
2
votes
2
answers
848
views
suddedenly increased in size of Log files form 32GB to 70 GB [duplicate]
I am not DBA ,but I need to check on the size of database files .
my database log files earlier was around 32 GB but from last few days it starts increasing and finally reached to 70 GB . first I ...
- 185
2
votes
1
answer
303
views
Delete log to increase DB space?
I'm running SQL Server 2008 Express and hitting the 4GB size wall. I'd like to make some space to give me time before i migrate to a larger DB.
I don't need my transaction log. So, can i delete ...
- 29
33
votes
6
answers
172k
views
Shrinking the log file does not reduce size
I have a database which has a 350 MB data file (.mdf) and a 4.9 GB log file (.ldf). The recovery model is set to FULL.
When I try to shrink the log file, it's not shrinking.
I know shrinking a ...
- 923