Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [transaction-log]

62 questions
3
votes
3 answers

SQL Server Log File Size Management

I have all my databases in full recovery and have the log backups happening every 15 minutes so my log files are usually pretty small. question is if there is a nightly operation that causes lots of transactions to happen and causes my log files to…
Rob
  • 201
  • 1
  • 7
3
votes
1 answer

Restore data from sql server 2008 transaction log

I have a sql server 2008 database that is in Full Recovery mode. I haven't made a backup of the database or log. Some data was inadvertently deleted from the database. I would like to go back to before the point in time that the data was deleted.…
Ronnie Overby
  • 681
  • 2
  • 12
  • 24
2
votes
3 answers

How do I minimize transaction log growth when copying data into SqlServer?

I've written a small app to periodically query, sanitize, and insert a legacy database's data into SqlServer. There are about 3M records and, if I make the polling widow pretty small, I can imagine the transaction log getting pretty big. How can I…
Dane O'Connor
  • 1,269
  • 2
  • 15
  • 20
2
votes
2 answers

SQL Server Transaction Log maximum file size

I have several databases, all in Simple recovery mode. There have been previous concerns about the log file sizes and I have shrunk them all using Management Studio's Shrink task. I have also placed a setting for the logs autogrowth to be a maximum…
Mike Richards
  • 123
  • 1
  • 1
  • 4
2
votes
3 answers

How should my hosting provider handle SQL Server transaction logs?

I received a support ticket today from my hosting provider (they created it), saying that my SQL transaction log had filled up and that they had truncated it, shrunk it and reset it to Full recovery model. I'm confused as to why they let the…
Tim Long
  • 1,738
  • 1
  • 21
  • 41
2
votes
2 answers

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works. From what I understand, (correct me if I'm wrong...) the log is actively stored in memory and copied to a file on the drive as often as…
Mirrana
  • 197
  • 2
  • 10
2
votes
2 answers

SQL Server 2005 log file is getting too large

I have an initial DB which I have to import very often during development, this DB is not large but it seems like the transaction log file is getting bigger and bigger, so each time I have to delete the database recreate it... Does any body know to…
O.O
  • 133
  • 14
2
votes
1 answer

Does the full backup truncate transaction log?

Does the transaction log get truncated when I take a full backup using command BACKUP DATABASE AdventureWorks TO Adventurewks GO Or do I have to take a log backup separately? BACKUP LOG AdventureWorks TO Adventurewks; GO Or is the log…
hyty
  • 431
  • 1
  • 5
  • 6
2
votes
3 answers

How to read the transaction log for SQL Server 2008

I'd like to know whether there is any way of browsing/searching the SQL Server transaction logs (any version). We've previously used tools such as Lumigent Log Explorer against SQL Server 2000 which fulfilled our need, but the product no longer…
MartW
  • 1,305
  • 10
  • 15
2
votes
3 answers

SQL Server 2008 log file grow ultra huge even in simple recovery

We have a database in SQL Server 2008 for which the Recovery model is set to Simple. Periodically, we run a big update on a big table (15 million rows to update). To accomplish this, we run a Stored Procedure which takes 2 hours+ to run. When the…
MaxiWheat
  • 237
  • 5
  • 12
1
vote
2 answers

Backing up 2 Exchange Servers in a DAG

A little explanation of our setup.. We have an Exchange 2013 in our main site with 1 Database Active on it and then we have a DR Exchange 2013 with the same Database but as passive. Users are currently connecting to both servers since the DR is a…
StefanGrech
  • 154
  • 2
  • 10
1
vote
0 answers

One database within a DAG filling up transaction logs

We run a fairly large Exchange 2010 DAG with 7 servers. 3 in production where all the databases are mounted, 3 in DR where they can be transferred should production go down and a LAG server on a 4 day lag. Due to reasons I wont get into, we are not…
Dave H.
  • 125
  • 1
  • 2
  • 10
1
vote
1 answer

Copy Exchange Database from Passive to Active

I have a CCR running with a total of 6 servers 2 MB, 2HT, 2 CAS. I had a failure on active node this morning and everything failed to my passive server, i had some issues with the logs, as the werent replicating to the passive, which made sense…
MrServer
  • 29
  • 1
  • 2
1
vote
1 answer

SQL Server 2008: Large transaction log file in Simple Recovery Mode

I am having a problem with disk space in SQL Server 2008. This is the situation: - I had a DB set with Simple Recovery and this DB used to use 2-3 GB for the transaction log file - I moved this DB to a new server and the situation was the same - I…
obiwankesoze
  • 33
  • 2
  • 5
1
vote
1 answer

Do MySQL transaction logs grow out of hand?

I used to manage Microsoft SQL Server installations. Now I'm up against a MySQL 5.1 server. On MSSQL, I remember databases have transaction log files which grow larger and larger as transactions occur. If you don't truncate the files every now and…
Gruber
  • 151
  • 3
  • 9
1
2
3 4 5