Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [transaction-log]

62 questions
0
votes
1 answer

Exchange 2010 Log Generation

We have an Exchange server which is generating roughly 7GB of Transaction logs per day, for a 75GB Database, does this sound normal? I'm fairly new to Exchange and am looking for some stats and averages really from other admins. The database has…
PnP
  • 1,684
  • 8
  • 39
  • 65
0
votes
2 answers

Sharepoint 2007 - Transaction log full

So I have this SharePoint 2007 site that is basically trash. I'm supposed to just toss it, but I'm in need of copying all of the data in form of traditional files and folders from certain projects. And since the transaction log is full, it's so damn…
Kenny Bones
  • 119
  • 2
  • 3
  • 14
0
votes
3 answers

SQL Server claims that transaction log is full, but it's not?

I'm trying to do a large INSERT operation from a database to another. But I get an error message: Msg 9002, Level 17, State 4, Line 1 The transaction log for database '_ARCHIVE_mydatabase' is full. To find out why space in the log cannot be…
kor_
  • 101
  • 1
  • 3
0
votes
1 answer

MSSQL Reduce Backup/Transaction Log Size Retaining Point-In-Time Restore

Current major problem with backup sizes - I have been through many questions but am finding conflicting scenarios. I have multiple databases with the same problem but using one as an example, here are the components of a backup file (26.2GB): Data…
Chris
  • 164
  • 2
  • 9
0
votes
1 answer

Giant SQL Server 2005 transaction log, don't understand why

My SQL Server 2005 database is having a giant transaction log. The MDF file is 11MB. The log is 1.5GB. Shrinking didn't release much space (9%). I already killed all my connections so I guess uncommitted transactions can't be the problem here. Any…
Koen
  • 103
  • 2
0
votes
1 answer

SQL Server 2008 R2 Transactions Files

Trying to restore a lost Server 2008 database. Had a backup from 2 weeks ago and were able to get the transaction log files. So I restored the DB in norecovery mode and started restoring the transactions log files since the full backup time. There…
Garfield81
  • 205
  • 4
  • 9
0
votes
3 answers

How can I get Transaction Logs to auto-truncate after Backup

Setup: Sql Server 2008 R2, databases set up with Full recovery mode. I have set up a maintenance plan that backs up the transaction logs for a number of databases on the server. It is set to create backup files in sub-directories for each database,…
Yaakov Ellis
  • 556
  • 1
  • 10
  • 15
0
votes
2 answers

SQL Server 2005 log file not truncating

Got something strange (to me ) going on with my SQL Server 2005 database. The log file has very gradually grown huge. Running dbcc loginfo('dbname') shows everything in the log is active (Status 2) Running dbcc opentran shows 'no active open…
Robin
  • 817
  • 3
  • 11
  • 20
0
votes
2 answers

Reducing the initial size of database log file

Microsoft SQL Server 2005 I want to reduce the initial size of a database (to a size below what it is currently) and then back up the log file. Is this a safe way of reducing the size of the log? Doing a log backup without reducing the initial…
Aushin
  • 1
  • 3
0
votes
4 answers

Shrinking Transaction log?

Why it is not recommended to shrink transaction log?
atricapilla
  • 615
  • 6
  • 12
  • 15
0
votes
3 answers

SQL Transaction log backups after Full SQL Backups

Environment: VM with 20 gb of HD space and secondary hard drive with 3 gb. Windows Server 2003 and Sql 2005 Backup Scenario: Weekly Full backups with Backupexec Nightly Diff. backups with Backupexec Daily 15 min. log file backups maintenance…
tjinak
  • 31
  • 1
0
votes
1 answer

Copy Transaction Log backup from Primary to non secondary server

I have a SQL Server 2005 log shipping set up, with a primary server and two secondary servers. The process goes like this: Primary backs up to independent network drive (not on any of database servers) Secondary(s) copy from network drive to local…
MrEdmundo
  • 291
  • 6
  • 14
0
votes
1 answer

Sybase 15.0 : Improving simple insert/select speed

What are the ways to improve performance of the following procedure: Every day I take a datafile, bcp it into an intermediate table without indexes (so that data import is as fast as possible), and then move it to a second table which has a lot of…
BarsMonster
  • 724
  • 4
  • 12
  • 26
0
votes
3 answers

SQL Server: Log file grows more and more, and do not get merged with the MDF file

My database files look very suspicious. we are using the DB in a production stage. and I'm seeing how the LDF file grows more and more. while the MDF file seems as it is not growing at all (I don't have a file size history to demonstrate it, but I…
SDReyes
  • 653
  • 2
  • 8
  • 15
0
votes
5 answers

SQL Server Transaction log Backup Frequency

I'm primarily a developer, but for one small in-house system I'm also currently in charge of some of the configuration of a server running SQL server enterprise edition. The database itself sees activity from two sources: A piece of client software…
Andy
  • 1,523
  • 14
  • 14
1 2 3
4
5