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…
![](../../users/profiles/119356.webp)
PnP
- 1,684
- 8
- 37
- 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…
![](../../users/profiles/63697.webp)
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…
![](../../users/profiles/87674.webp)
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…
![](../../users/profiles/27846.webp)
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…
![](../../users/profiles/92353.webp)
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…
![](../../users/profiles/84565.webp)
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,…
![](../../users/profiles/34.webp)
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…
![](../../users/profiles/4099.webp)
Robin
- 807
- 3
- 11
- 19
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…
![](../../users/profiles/67441.webp)
Aushin
- 1
- 3
0
votes
4 answers
Shrinking Transaction log?
Why it is not recommended to shrink transaction log?
![](../../users/profiles/36019.webp)
atricapilla
- 605
- 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…
![](../../users/profiles/46500.webp)
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…
![](../../users/profiles/2628.webp)
MrEdmundo
- 291
- 5
- 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…
![](../../users/profiles/34947.webp)
BarsMonster
- 644
- 3
- 11
- 24
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…
![](../../users/profiles/41615.webp)
SDReyes
- 643
- 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…
![](../../users/profiles/3351.webp)
Andy
- 1,493
- 14
- 14