All Questions
Tagged with sql-server transaction-log
593
questions
0
votes
1
answer
54
views
how can I add the date and time on the autogrowth query below?
while trying to prevent autogrowth from happening,
I got this nice script here.
however, if it does happen, I need to know how to find it out.
that I can do using this very nice script by Max Vernon.
...
- 16.3k
1
vote
2
answers
97
views
Understanding Recovery Forks in SQL Server: Meaning and Significance
I'm trying to understand the concept of recovery forks in SQL Server, particularly in relation to the sys.database_recovery_status view. The documentation mentions several columns related to recovery ...
- 2,030
2
votes
2
answers
195
views
Transactional Replication - how to set up alerts/notification to send alerts before transaction log space is full on a Publisher?
I am setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL recovery mode. Log backup is taken every 15 ...
- 27
0
votes
1
answer
67
views
How to remove secondary log file when SQL thinks it isn't empty
I had to add a log file to my database to do a one-time load of data in my SQL Server 2019 database in simple recovery model. I added the file with
ALTER DATABASE db ADD LOG FILE (NAME=log2,FILENAME='...
- 1
0
votes
1
answer
50
views
What happens if the Subscriber goes down - will the t-logs keep accumulating on the publisher in Transactional Replication?
I am trying to consider all the options before setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL ...
- 27
-3
votes
2
answers
79
views
2x SQL Server 2019 in AlwayOn group - how to remove transaction log [duplicate]
We have a problem with our Microsoft SQL Server 2019. We have 2 servers in an Always On group with one database. Problem is the actual (real) database size which is about 1 GB, but it takes up around ...
- 1
-1
votes
1
answer
64
views
How do you eliminate extra transaction log files?
I started a new job taking over for a guy that really did not know what he was doing.
He created multiple transaction log files for most of the databases on the server.
Apparently, he did not know how ...
1
vote
1
answer
70
views
Avoid logfile getting too large on SQL Server
I have a SQL Server stored procedure that essentially 'flattens' a complex database into a single, simplified, table in a separate database to allow users to query the data without needing to ...
- 13
0
votes
1
answer
46
views
Does Azure automated backup for SQL database on Azure VM have way to detect log chain?
I have SQL server on Azure VM.
If I enable Azure automated backups for the SQL server on Azure VM to backup the dbs (full/diff/log), and suppose if an admin performs a manual log backup (which ...
- 3,476
0
votes
1
answer
59
views
Ideal VLF size - SQL Server transaction log
Is there an ideal size for the VLFs in a transaction log. This is a system with AlwaysON and Transactional replication. I was wondering if there is any cons to creating large VLF's. Eg, lets say ...
- 1,750
0
votes
1
answer
197
views
what to do when database is not synchronizing in availability groups?
I am using
Jonathan Kehayias - Monitoring Availability Group Replica Synchronization
SELECT
ar.replica_server_name,
adc.database_name,
ag.name AS ag_name,
drs.is_local,
drs....
- 16.3k
0
votes
0
answers
70
views
Database log file is so big
My database log file is so big(400 giga) and data file is (50 giga)
My recovery method is simple and backup plan is daily full backup
Log file is configured to auto growth.
I checked open transactions,...
0
votes
0
answers
58
views
A 27GB Table Population causes the TLOG to grow to 211GB
my brain is fried.
I work in an organisation where every night we pull data from the source system into a staging area, then into production and because of this we have out DB's set to Simple Recovery ...
1
vote
1
answer
55
views
Release Database Transaction Log File Freespace In SQL Server 2016 [duplicate]
Good afternoon,
We have 4 node SQL Server configure in HA/DR. Periodically, we purge the old data to free up the space. Recently, after the SQL Job to purge the data was executed, we notice an ...
- 13
0
votes
1
answer
85
views
Log .ldf file not truncate after several times of log backup on secondary database
i have always on setup in production environment. Scheduled backup (transaction log backup) already in place every 2 hours using netbackup on secondary database.
The issue i am facing is sometimes the ...
- 11