Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
2
votes
1answer
302 views
Maintenance Plan Takes Too Long - Locks Tables - Indexing To Blame
System:
I have a Maintenance Plan that Rebuilds Indexes for Several Tables (10 tables, 50M records total).
Issue:
During the Index Rebuild (~20 minutes), we fail to insert data into the DB
...
2
votes
2answers
1k views
SQL Server 2008, switching to simple recovery mode
Currently our transaction log is 50 GB; impressive huh?
I want to switch to simple recovery mode and remove the transaction log entirely.
Do I need to stop any user activity and detach the database. ...
2
votes
2answers
85 views
separating tlog and db file when using fusionio
We have a FusionIO card that we use in our production database. We have both the transaction log as well as the database files on that same drive. I know the recommendation is to place the tlog files ...
2
votes
2answers
268 views
How do you fix Autogrowth being set to 12800%
We're running SQLServer 2005 SP1 and for some weird reason our one database transaction log automatically changed it's Autogrowth to 12800% which isn't even a valid number. I cannot change the growth ...
2
votes
2answers
58 views
Transaction Log maintenance when switching to Simple Recovery
Background:
I recently inherited 50+ SQL Servers with 450+ databases. The nightly backups are roughly 8TB and, needless to say, we're using more disk space than we'd like. All of the databases are ...
2
votes
2answers
298 views
How can I find databases with a large number of virtual log files?
I have several databases on a production server that are in the hundreds of gigabytes, and have many thousands of transactions running through them on a daily basis.
Almost all these databases are ...
2
votes
1answer
756 views
Disable SQL Server Log Shipping to nonexistent destination
I am administering a SQL Server 2008 instance in a dev environment. At some point before I became an administrator, someone enabled log shipping from one of the databases on this dev instance to ...
2
votes
1answer
204 views
Postgres synchronized backup - what's with the archive?
I am setting up a Postgres 9.1 master and a hot standby-server. I read the documentation but I'm not quite sure yet what I should do with my WAL files.
Every commit is done on both servers before ...
2
votes
1answer
70 views
Restoring a database back to a point in time before full backup was made
A problem with one of our database tables arose at the end of last week and I wanted to restore that database to a server in order to retrieve the table. We only have the last backup, and a full set ...
2
votes
1answer
236 views
SQL Server 2005 Percent Log Used Alert fires too fast?
I have a SQL Server 2005 database thats roughly half a terabyte. Third party software that I don't control writes to the database.
I have a Maintenance Plan which backs up the transaction log, and ...
2
votes
4answers
345 views
Does a full transaction log cause a rollback?
Will a transaction that is trying to write something into the transaction log be rolled back if the transaction log is full?
2
votes
5answers
2k views
Keep transaction log size under control during batch processing
tl;dr
I think my verbosity has obscured the real question I'm asking here, so I apologise for that. My main issue is that the checkpoint command appeared to be working for at least 800 iterations of ...
2
votes
1answer
177 views
Initial recovery Postgres with backup in sync commit mode
I've got a master and a slave postgres 9.1.3 database. I would like to init the backup database for the first time.
I did the following steps:
Stopped master
Copied all files to Slave
Create ...
2
votes
2answers
161 views
Will removing a 2nd log file break log shipping?
We have a large database 200GB+ to which we added a second log file to cater for growth during an upgrade. This is now no longer needed so we want to remove it. Normally this would be a simple ALTER ...
2
votes
1answer
280 views
PostgreSQL WAL Archiving: Does having archive_mode set to 'on' without copying logs cause performance issues?
Using PostgreSQL 8.4/CentOS 6: if I set the archive_mode parameter to on in postgresql.conf, but don't actually store the generated WAL files anywhere via the archive_command parameter, is there any ...
2
votes
1answer
59 views
Searching transaction logs for changes
I currently have a database with an attached CMS. The CMS has about 50+ people with various permission levels that can log in etc... I would like to know if there is a way I can look at the ...
1
vote
3answers
203 views
Point in time recovery from the same database - what does it mean?
I have two questions. I have a database in full recovery mode. Lets call transaction log an LDF file for short.
SQL Server allows me to restore to point in time in the past when restoring from ...
1
vote
2answers
210 views
Reducing high VLF count
I have been using Brent Ozar's sp_blitz script to review our database setup and have found that the VLF count is high (13562!) on the primary DB since changing to Full recovery model.
I ran a full ...
1
vote
2answers
91 views
Who changed the size of the transaction log?
Can I know, who and when changed size of database transation log?
1
vote
1answer
270 views
SQL Server - how transactions and transaction log work (simplified)
I have a theory on how transactions work, but I would like if someone could verify it or correct some points if possible. Let's consider we have a database with full recovery model.
Now, everything ...
1
vote
2answers
100 views
Missing or lost transaction and no errors to show what went wrong
I have 2 missing records in SQL Server and I am trying to identify the problem that caused this issue.
New records are inserted using a stored procedure, which will return an error code to the ...
1
vote
1answer
606 views
Why does my transaction log use so much space?
I have a staging table with 20 million rows that uses about 8GB of storage. After populating foreign keys and sanitizing data I need to move this data into a production table (which does not need all ...
1
vote
1answer
255 views
In Sybase, what can I do to figure out why my Transaction Log is filling up?
We have a process that runs each morning to load about 40,000 rows from one server to another. In the past few weeks, the process has been having a 'log suspend' once or twice a week. This is ...
1
vote
3answers
231 views
Big size of database logs SQL Server 2008
I have a database which is running under Microsoft SQL Server 2008. Now, I have seen that the log of the database (the .ldf file) is growing to big size. The database file (.mdf) has a size of 630MB ...
1
vote
1answer
57 views
Online backups with VENDOR library: what should be set for ACTIVE LOG PATH?
My customer is using Veritas NetBackup so we use its library file in the LOGARCHMETH1 parameter for the VENDOR option. That is for archive logging path.
What path should be set for ACTIVE LOG PATH ...
1
vote
2answers
626 views
SQL Server 2008 - Log file out of control & cant shrink it [duplicate]
Possible Duplicate:
Why Does the Transaction Log Keep Growing or Run Out of Space?
I am having trouble with my database, the log files is currently 250GB in size, I need to shrink this down ...
1
vote
4answers
109 views
Simple model database transaction log full 'CHECKPOINT'
I have a SQL Server 2012 SP1 database which has a problem that the transaction log is full. It consists of a single data file and a single log file, both about 800MB.
I had 5GB free disk space, and ...
1
vote
0answers
226 views
SQL Server Troubleshooting Replication and Long-Running fn_dblog query
I am trying to get (pull) Transactional Replication working again for a subscriber.
Currently, in Replication Monitor I am seeing messages in the Publisher to Distributor tab and the Distributor to ...
0
votes
2answers
71 views
Shrink transaction log while transaction in progress
I have a several-GB import into my SQL Server 2005 (Standard Edition) database.
The import is separated into 4 parts, each part in its own transaction.
As you can guess, the transaction log files ...
0
votes
2answers
141 views
Restore to a point between two full SQL Server backups
I have two SQL Server database backups from Server1. Backup1 was made on, say, 2013-01-01 and Backup2 was made on 2013-01-03. What I want to do is restore Server2 to the intermediate state on ...
0
votes
1answer
351 views
How to manage a large SQL Server database: transaction log, reduce size, alter table
Hello I have some confusion on how to manage a large SQL Server database.
Let's say size is 15GB, with 3GB available, in simple recovery mode.
Server is not managed by me, I cannot change the size, ...
0
votes
1answer
88 views
How are transactions logs inserted?
I have an ms-access database at work that has a table that's a transaction log.
The table contains the following fields:
Date - The date the transaction took place.
Table_Name - Name of the ...
0
votes
3answers
1k views
What is the purpose of having a table NOT LOGGED INITIALLY
I came across this recently. When defining a table in DB2 LUW (at least 9.5 or higher), you can define it as NOT LOGGED INITIALLY.
Example from the book I read:
CREATE TABLE products (
productID ...
0
votes
2answers
298 views
SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs
After doing some research I cannot seem to find an answer to this question.
Background
I am attempting to setup a backup plan that fits the following three requirements:
Reliability of backups, ...
0
votes
2answers
635 views
How to disable ldf file or limit its size [duplicate]
Possible Duplicate:
Why Does the Transaction Log Keep Growing or Run Out of Space?
My .ldf file size keeps increasing. I already tried to shrink it but after that it just grows again.
How ...
0
votes
1answer
277 views
IBM DB2 9.7, possible to temporarily disable transaction logs?
I want to clean the whole database, so I am dropping all tables and DB objects in two FOR loops, within one transaction. This makes the transaction logs become full. I could increase the transaction ...
0
votes
1answer
56 views
SQL Server automatic transaction log truncation
Have looked through msdn but cant find answers to these:
Any help much appreciated:
In simple recovery mode:
Is there any TSQL or alternative functionality that will provide a notification either ...
0
votes
2answers
97 views
SQL Server transaction log [duplicate]
Possible Duplicate:
Why Does the Transaction Log Keep Growing or Run Out of Space?
Is it possible to have SQL Server 2008 R2 reset the transaction log for certain databases when the ...
0
votes
0answers
19 views
SQL Server 2008 log file growing and wont shrink. Hard Drive Space running out [duplicate]
I have a SQL Server 2008 database which has a log file (.ldf) with a size of 360GB and growing every day.
The .mdf file is only 25GB. The hard drive is 950 GB and has 150GB free space. I want to ...
0
votes
0answers
32 views
Performing a Transaction Log Backup on a Live Database [duplicate]
I have a server 2012 database that has a transaction log that is growing at a rapid rate. i have a job that runs once a day after production hours which backs up the log file and shrinks it.
The ...
0
votes
2answers
111 views
Database not naturally shrinking log file [duplicate]
I have a database that is set to Simple recovery mode. There is 99% free space in the log file and I can manually truncate the log file right down to 500 MB.
The next day, after a daily import ...
-2
votes
1answer
195 views
Can the transaction log in SQL Server 2008 Express edition be viewed in text?
Is it possible to read the transaction log in text/table format, and if so, how can I do that?
-4
votes
5answers
2k views
Safely deleting a SQL Server log file (.LDF)
I can make sure my app is in a consistent state.
I can rollback all the uncompleted transactions if any (just in case) it's ok
I can DETACH the database
What do I need the log file for after that?
...
