Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
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 ...
4
votes
3answers
180 views
Disabling logging on certain tables
I'm using SQL Server 2005. I have two tables that contain aggregate information. The information is constantly being updated, generating almost 5GB of log data a day. (That's larger than the entire ...
-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?
2
votes
3answers
148 views
Transaction Log file .ldf is too small
Current database is almost 200GB however the transaction log file is only 4.1GB.
I am worried if this influences the performance of databse and how could it be solved.
When I do this query
DECLARE ...
4
votes
2answers
165 views
How do I tell what is filling up the transaction log?
We have a transaction log on a sql database and for some reason it has filled up to 50GB when our live system only has about 2GB. Is there any way I can profile sql or the transaction log to try and ...
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 ...
5
votes
1answer
93 views
Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?
The Setup:
Say we have a Database in Full Recovery Mode that does a nightly Database Backup, Transaction Log Backup, and Transaction Log Shrink.
Now the Transaction Log grows so quickly during the ...
2
votes
2answers
299 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 ...
6
votes
1answer
659 views
SQL Server transaction log file refuses to grow
Problem: I have a SQL Server database sitting on a 1 TB drive. The log will not grow past 5 MB even when the MAXSIZE is set much larger than 5 MB.
Error received:
The transaction log for database ...
6
votes
3answers
2k views
View delete statements in the Transaction log
Is it possible to view delete statements that have recently occurred in the Transaction Log?
6
votes
2answers
824 views
SQL Server 'Create Database' statement. How to inherit autogrowth settings?
I am using SQL Server 2008 R2 and creating databases through continuous deployment.
In our system, the default 1Mb/10% autogrowth settings in SQL Server work badly with our data. Particularly as we ...
-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?
...
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 ...
3
votes
3answers
257 views
When are Archived Redo Logs generated?
We have an instance in Oracle 10g. Only one schema is used for a web application (Internet-facing), which is only user for reading information, no adding or modifying data. The rest of schemas are ...
4
votes
1answer
1k views
MS SQL Server - Checkpoint process stuck in SLEEP_BPOOL_FLUSH
We seem to have a problem that came out of nowhere. The checkpoint process is stuck in SLEEP_BPOOL_FLUSH state, and not actually reducing the usage in the log file.
This never seemed to happen ...
7
votes
3answers
265 views
Is there a performance benefit to placing transaction log files on a separate drive?
There are many blog posts and best practice articles extolling the virtues of placing the SQL Server data file on one hard drive and the transaction log on another. The reason given is that that the ...
3
votes
3answers
312 views
Is it possible to recover day's worth of queries from sql server log file?
I lost all data entered and edited in my system yesterday, and my ISP has announced to me that last night's backup is corrupt and cannot be recovered.
Is there any way to access the database's log ...
4
votes
1answer
386 views
Transaction Log Truncation with Copy Only
I have a database backup job set to use full backup with the Copy only option on once daily. The copy only is on because from what I have read that is the only way to backup a database that is ...
3
votes
2answers
403 views
SQL Server 2008 Query Saved in Logs?
Every time I create a query and run it to create a report I save the query in my Projects folder in case I have to rerun the query in the future or if I have to modify it for any reason but it seems ...
12
votes
2answers
706 views
SQL Server how to get around the transaction log filling up when updating a column to an int
I have a SQL Server 2005 table called BRITTNEY_SPEARS_MARRIAGES and it has the following columns:
MarrigeId tinyint,
HusbandName varchar(500),
MarrigeLength int
Now I have another table ...
4
votes
2answers
517 views
Transaction Log and mirroring - looking for dumbest explanation possible
First of all I must admit that I struggle with concept of Transaction Log. I mean - I do understand that it is Log of all Transactions that happen on database, but when it comes to properly putting it ...
4
votes
1answer
116 views
Does the PCI require to protect the Credit Card Info in the transaction log?
The PCI Data Security Standard https://www.pcisecuritystandards.org/documents/pci_dss_v2.pdf
forbid storing Credit Card info in the transaction log
3.2.1 For a sample of system components, examine ...
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 ...
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 ...
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
237 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
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
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 ...
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 ...
6
votes
1answer
407 views
DBCC CHECKDB firing every 20 - 60 seconds
I have a dev environment that is rapidly approaching deployment into production and have noticed in the logs that roughly every 20 seconds I see the message:
Starting up database 'dbname'
CHECKDB for ...
3
votes
2answers
619 views
Is this procedure to Failover to Logshipped secondary and Fail back again procedure correct?
I have a primary database in Amsterdam (AMDB), and a secondary in London (LNDB). I want to fail over from AMDB, to LNDB and then back again, without having to make another full backup (because the ...
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, ...
3
votes
2answers
2k views
How to monitor SQL Server data and log file growth?
I'm trying to find a way to monitor data and log file size from SQL Server databases (within an SQL Server instance). I would not want to use third party tools, but simply pure SQL or PowerShell. I ...
3
votes
2answers
387 views
What is the undo pass that SQL Server does during a RESTORE WITH STANDBY operation?
It's my understanding that SQL Server generates undo files when applying a restore to a database using the RESTORE WITH STANDBY.
From the MSDN documentation (Emphasis mine):
The standby file is ...
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
1answer
759 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 ...
4
votes
4answers
241 views
SQL Server restore from transaction log
In SQL Server 2005, if you have a database with no backup - but it is running in full recovery mode - is it possible to "roll back" some deletes?
If yes - how?
2
votes
4answers
346 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 ...
4
votes
1answer
1k views
Whats the difference between Transaction logs and Binary logs?
Coming from a SQL Server shop, I now work with MySQL and I was curious.
What are the differences between MySQL's binary log and MSSQL's transaction log?
By the outlook thus far, it seems that there ...
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 ...
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 ...
3
votes
1answer
198 views
Does blocking always mean open transaction?
This may seem a bit dull question but does blocking always mean that there is open transaction and that may cause transaction log grow to infinity because open transaction prevents log truncation ...
