All Questions
Tagged with transaction-log sql-server-2012
7 questions
0
votes
1
answer
2k
views
Very Low "Used Log Space Percentage" for SQL Server database transaction file
Prologue
I have always read/observed that we should not shrink database file as they tend to grow back. There will be a performance penalty when DB will try to grow these files if there is not ...
- 499
0
votes
1
answer
10k
views
The transaction log for database is full due to 'log_backup' / (Log)LDF file 4 times bigger than (Data)MDF
Of course I found many posts to the problem of "log_backup". But my question is now: what is the right / correct / professional way to handle this kind of problem?
My database file is approx 20GB, ...
- 1
0
votes
1
answer
2k
views
Database mirroring out of sync after Transcriptional log backup
In SQL server Database mirroring, I need to bring down the Mirror server for maintenance for 2 hours. However If I have a transaction log backup on the Primary database running every 15 mins, Will ...
- 25
0
votes
0
answers
69
views
Why SqlServer needs a big transaction log file
I've been working in a SQLServer 2012 database for several years at work and I have always wondered about a strange thing I have observed with transaction logs. I 've been searching on Internet and ...
- 81
0
votes
1
answer
85
views
SQL Server 2012 is not using transaction log
I have a SQL Server 2012 Express.
Now, I have seen, that it is not using the log-file anymore. The size of the log file is always 2MB and the changedate is in the past. The database is in high use so ...
- 6,249
0
votes
1
answer
380
views
Disk full because of transaction log caused by expensive query
I have a problem with a query that could look simple but it is causing me a lot of problems here in my development environment.
What I'm trying to do is to change the articleID by a new article ID ...
- 82
0
votes
0
answers
2k
views
Transaction log clearance of a DB in SQL Server 2012 when DB is part of always on
We have a DB which is part of ALWAYS ON. We want to clear the transaction logs for that DB because that is just a production server where we replicate data from one of our other production server 4 ...
- 975