Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.

learn more… | top users | synonyms

0
votes
1answer
16 views

How can I handle a huge amount of logging generated from frequent table rebuilds?

We have several tables which we "refresh" frequently by rebuilding them in a staging-table, then performing a metadata-switch to the production-table using the ALTER TABLE <source> SWITCH INTO &...
0
votes
2answers
24 views

Transaction Log Backup Cleaning [duplicate]

If you back up your transaction log every hour through a maintenance plan, why does your log file continue to grow? I would think the system would delete or shrink the log after the backup. Is this ...
0
votes
2answers
54 views

Should I shrink the Log File

I am a developer but have to do DBA stuff now and then. We had a problem where the Transaction log files of our DBs where increasing to large size of 50GB while the data file (MDF) was only 10-15 GB. ...
2
votes
2answers
20 views

Concurrent backups (full and transaction) and testing recovery model

My intent is to test my recovery model and setup log shipping to replicate a database on another server. I have a database called AdventureWorks on a primary sql server. Presently SQL Backup performs ...
0
votes
1answer
23 views

Necessity of backing up tail log when restoring transaction log?

I have a question about whether or not it is necessary to back the tail log up when performing a restore of a database in Full Recovery mode. I've sprawled for a good while now, and have gotten ...
3
votes
2answers
58 views

Applying Transaction Logs to an existing Database

I am wondering if this possible, I can not seem to apply another transaction log. I have restored the Full database backup, the differential backup and my last Transaction Log WITH RECOVERY. If later ...
1
vote
1answer
46 views

Log and Data Drive Configuration in VM environment

Anyone have any good feeling on how to arrange the underlying disk configuration for a VM (Hyper-V) implementation of SQL Server vs installing straight up on the hardware? For a native Install, best ...
3
votes
0answers
90 views

Heavy I/O for Microsoft Transaction Log

We have a Microsoft SQL Server (SQL Server 2012 SP3), we've noticed that transaction log I/O is very high. We do have a busy server; we're hosted at Rackspace with SSD block storage. The Logs are are ...
2
votes
1answer
60 views

What is the cardinality of entity relationship between Employee and Department?

Recently, a friend of mine asked me this question about the cardinality between a Department and Employee entities, I replied many to many, then he, my friend, showed me drawings from the internet ...
1
vote
2answers
84 views

Affect of Shrinking Database before Transaction log backup

I am newbie in the world of Database administration, so excuse my stupid question :) I have the following maintenance jobs scheduled through SQL Server Management Studio : Full DB Backup at 2 am, ...
0
votes
0answers
67 views

MySQL: Log only 'select' queries executed on a specific set of tables of a database

I have a Magento site in which I want to log only SELECT queries(after SELECT it could be any column or all columns, in short all SELECT statements) executed on a specific set of tables, also as it's ...
1
vote
0answers
68 views

Log file on SQL Server 2014 grown out of control - LOP_SHRINK_NOOP

Server is SQL Server 2014 running in SQL Server 2008 compatability mode. Recovery Model is Full. We have auto shrink turned on (seems this is related to LOP_SHRINK_NOOP) We have about 4.5 million ...
6
votes
1answer
65 views

Best way to backup & truncate transaction logs on a schedule

I'm no DBA, but things being what they are, I have to wear the DBA hat and set up maintenance plans on my SQL Server instance. So for a while I've been having my SSIS overnight process run a Execute ...
1
vote
2answers
93 views

MySQL doesn't log queries anymore

Some time ago I updated my MySQL server to the v5.6: SELECT VERSION(); 5.6.30-0ubuntu0.14.04.1 Now the query logging isn't working though the configs in the /etc/mysql/my.cnf seem to be correct: [...
3
votes
2answers
289 views

What exactly is written to transaction log?

Here's the scenario: DB with Simple recovery model, Roughly 14 GB of data (~80 million rows), INSERT ... SELECT statement into empty table with 7 non-clustered, non-unique, single column indexes and ...
1
vote
1answer
55 views

SQL log file growing exponentially [duplicate]

We have a SQL database on FULL back up with a client and they have NOT implemented a Log file maintenance and noticed that the log file grows exponentially, filling the 20GB they have allocated to it ...
0
votes
0answers
43 views

Shrink Log file in an Always On Availability Group [duplicate]

My LDF file is too big (almost 500 GB) because we had some problems. I know that is not good to shrink files, but we need to do it this time. My database is using the FULL recovery model and is in ...
5
votes
1answer
69 views

Index creation leads to large transaction log growth

I have an approximately 1 billion row table. I then create an index as follows: CREATE NONCLUSTERED INDEX [IX_Index1] ON [dbo].[MyTable]( [CustomerID] ASC ) -- CustomerID is uniqueidentifier WITH (...
0
votes
0answers
25 views

Secondary database log file in alwayson is very big [duplicate]

I have an alwayson environment (AlwaysOn AG). Database [UsersDb] in the slave server, His log file is very big . How can I reduce his size(shrink)?
1
vote
1answer
50 views

Create a stored-procedure to insert multiple rows on a junction table and other tables

I am new to Databases and Design and needs some help on a INSERT issue. I want to create a procedure that will insert multiple values to different tables, I need to make sure it stays atomic so I need ...
1
vote
2answers
105 views

Reclaim Transaction Log space of SQL Server

I have a SQL Server databases for which log files have grown huge. I have log backup scheduled to run only once a day. But now all the disk space is used by these log files. Can anyone help me ...
12
votes
3answers
176 views

Keeping (Partial) Backups Small when using SQL Server FILESTREAM

I have a database with nearly 1TB of FILESTREAM data that I don't need backed up (if the data was deleted it'd be recreated automatically in a couple of hours, so it just isn't important). Most of the ...
3
votes
4answers
133 views

Is it enough to have only full backup and transaction log backup only for a good backup plan?

If Full backup is scheduled for every Sunday at 12 pm and differential back up is scheduled for for every 6 hours and transaction log backup is scheduled for every 15 minutes. My problem is what is ...
0
votes
1answer
43 views

Clear out remnant LDF log files of Sharepoint DB not visible on SBS 2008 Domain Server?

Typical ways for dealing with LDF files that take up a lot of space, recommend these processes to shrink/ eliminate the drive space being occupied. http://www.sharepointboris.net/2008/10/sharepoint-...
3
votes
1answer
78 views

Tempdb log file was growing continuously on SQL Server 2008 R2-SP2. Could a pending insert statement which uses temporary table be a cause?

I just started at my new job as a DBA. All of a sudden, we started getting alerts about disk space. When looked into it, I found that tempdb log file was growing continuously. There was an active ...
1
vote
0answers
19 views

MySQL quick database transfer between two servers

I am migrating a reasonably large (18GB) database used for a website from one server to another. There are two tables which make up 95% of that size and they do not have to be fully transferred for ...
0
votes
1answer
34 views

SQL Server 2014 log growing just in Navision 2015 just when always on is active

My question is about if anybody can help me to find out why my LOG file growing to more than 2T just when I activate ALWAYS ON in my NAVISION database. I have more databases in my SQL Server 2016 and ...
0
votes
0answers
36 views

The transaction log for database is full due to 'ACTIVE_TRANSACTION' [duplicate]

We are facing problems related to transaction logs becoming full. The transaction log for database is full due to 'ACTIVE_TRANSACTION' My database logs are becoming full after every 4-5 days &...
0
votes
1answer
91 views

Backup transaction log from secondary database in alwayson AG

Is it possible to do the log backup from the secondary databases in the AG?
1
vote
1answer
58 views

Can't do a full backup because the log is full [duplicate]

I have a server with 25GB of free space. The software stopped working because the transaction log is full. I noticed that the database has two logs files; one is 45Gb and the other is 65Gb. I think ...
0
votes
1answer
21 views

How to restore a transaction log

Could you tell me the reason why it is mandatory to restore the full backup with NORECOVERY option before restoring the transaction log? otherwise Transaction log is always grayed (Task -> restore -> ...
2
votes
1answer
70 views

backup log larger than log file

Today I noticed that the backup of the log of our database was 18GB but the size of the log file is only 8GB. I used the following command to backup: BACKUP LOG [myDB] TO DISK = N'g:\sqlbackup\LOG\...
2
votes
2answers
88 views

Backup Strategy for Transaction Log. Tail or Standard Log Backup?

We are forced to perform some essential maintenance on one of our production environments. Instructions from the vendor state the recovery model of the database should be set to SIMPLE before the work ...
-3
votes
1answer
52 views

SQL Server 2008 R2 - Rebuild Log

I'm trying to rebuild a log file for my database. I want to know if what is happening is normal. This is what I'm doing: use master ALTER DATABASE my_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER ...
0
votes
0answers
17 views

3023 : File serialization issue with transaction log backups

I am trying to take a transaction log backup on one of the AO replica servers. It throws an error saying that backup operations must be serialized. I googled this and found that only one backup should ...
0
votes
1answer
74 views

Sql Server log: is 'Backup|Log was backed up' the same as 'BackupDatabase: Log files done'?

One transaction log file is growing and growing for a couple of days and I can't find out why. Now I figured out that either the way the activities are stored in the sql logfile OR the behaviour of ...
2
votes
1answer
62 views

Why can a log backup not be taken without first taking a full backup?

I've created a new database using the FULL recovery model. Now I am trying to take a log backup without first taking a full backup. I'm aware that SQL Server won't allow us to do so, but I want to ...
0
votes
1answer
44 views

Will an hourly T-Log backup in a Maintenance plan write a file if there are no changes to a DB?

I have an hourly maintenance plan the runs a T-Log backup. Some of my databases may have every hour represented in the file system, while others have some hours "missing" or even none at all. Is it ...
2
votes
1answer
137 views

What is the role of eager writer?

What is the role of eager writer? How this process works internally in SQL server? What is the major difference between eager writer and lazy writer/checkpoint? My understanding here is, that both ...
1
vote
1answer
41 views

Transaction Log file size is increasing in my Azure (IAAS) SQL Server 2014 database [duplicate]

Recently we have migrated our application (both web app and database) to Azure (IASS). There we have a VM with SQL Server 2014 installed. Also I have restored all the necessary databases and SQL ...
1
vote
1answer
32 views

Hsqldb transaction log rollback cause

I'm fairly new to the database world but I had to use an hsqldb-2.0.0 database for a netflow collector software. As the software shows no output even if the client is collecting the flows I ...
2
votes
0answers
45 views

SQL server database log full for application databases [duplicate]

We have an issue that our application database gets log full because we have a schedule job to write to a flat table for reporting purpose every hour in the application database. I wonder if we should ...
1
vote
1answer
54 views

Transaction log rollback broke Log Shipping chain?

Is it correct that performing a transaction log restore to a previous point in time will break the log shipping chain? If this is correct, is there a way to recover from this situation without having ...
1
vote
0answers
51 views

LogFile Size increases by SSIS Package execution

On production server we have 125 GB free space. The SSIS package is doing some delete in Transaction. e.g. Insert 3 columns which are mainly business keys into a staging table and then deleting the ...
0
votes
2answers
41 views

Transaction log backups cleaning

I have a quick question regarding the cleaning of no longer necessary transaction log backups. So, I have a database in FULL recovery mode. Every night, at 10 PM a backup takes place (via maintenance ...
6
votes
2answers
109 views

How exactly the row visibility is determined?

In the simplest case, when we insert a new row into a table (and the transaction commits), it will be visible to all subsequent transactions. See xmax being 0 in this example: CREATE TABLE vis ( ...
3
votes
1answer
193 views

The transaction log for database 'database' is full due to 'LOG_BACKUP'. Nothing works

I have about 30 databases on SQL server 2012. One of the databases is erroring with "The transaction log for database 'database' is full due to 'LOG_BACKUP'." I have spent several hours googling and ...
0
votes
2answers
78 views

How many log files does a database usually have? [duplicate]

I'm studying SQL Server. I have read that a database can have several data files and one log file, but recently I was heard that a database can have more than one log file. Is this true?
2
votes
1answer
45 views

High Log Space Used for model System database

I was running DBCC SQLPERF(LOGSPACE) and noticed that while my user databases have nice, low Log Space Used percentages, my model system database is currently at 98%. I have it set to the default Full ...
0
votes
1answer
58 views

Reduce the allocated size of a DB file [duplicate]

Is it possible to reduce the initial log-file size of a DB. See the screen-shoot below, the log-file shouldn't be more than 500 MB with an autogrowth of 100 MB. I dont want to shrink the file, i want ...