The transaction-log tag has no wiki summary.
1
vote
1answer
71 views
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 ...
0
votes
1answer
82 views
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 ...
2
votes
1answer
199 views
Restore transaction log backup - media family error
Our backup procedure is as follows: midnight full backup, every 8 hour differential backups, and every 5 minutes transaction log backups. Maintenance plans keep everything rolling and tidy.
To ...
2
votes
1answer
185 views
How can I force a merge of all WAL files in pg_xlog back into my base “data” directory?
Question:
Is there a way to tell Postgres (9.2) to "merge all WAL files in pg_xlog back into the non-WAL data files, and then delete all WAL files successfully merged?"
I would like to be able to ...
0
votes
1answer
321 views
Advised auditing method for MS SQL to track changes made to a specific table by a specific user?
What is the best method for tracking changes or logging the queries done to a table by a specific user when the person is using Management Studio?
I'm using 2008 R2 Express Edition and want to ...
0
votes
1answer
386 views
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 ...
0
votes
1answer
71 views
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 ...
2
votes
2answers
399 views
Simplest way to shrink transaction log files on a mirrored production database
What's the simplest way to shrink transaction log file on a mirrored production database?
I have to, as my disk space is running out.
I will make a full database backup before I do this, so I don't ...
0
votes
2answers
138 views
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. ...
4
votes
1answer
282 views
My log file size is 121 GB how to reduce?
We are using Navision 2009 and the database transaction log file has grown to 121GB. We would like to shrink the file. Can this be done?
1
vote
2answers
1k views
Exchange 2003: When do transaction logs get committed and why is the archive bit not set?
The instructor got me confused on this one:
Exchange transaction logs get committed during full/normal backup. Incremental and differential backups only backup the logs. OK that is clear. But he also ...
1
vote
2answers
120 views
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 ...
0
votes
3answers
154 views
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' ...
0
votes
1answer
148 views
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 ...
0
votes
1answer
59 views
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 ...
0
votes
0answers
81 views
SQL Marked Transaction Log Confusion
I'm struggling to build a SQL DB sample where I restore a marked transaction log.
What I did
After ensuring that the DB is really in full recovery mode, I made a full backup, and then a transaction ...
2
votes
3answers
445 views
SQL Server transaction log BACKUPS are very large
In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model.
The problem is that the backup files for ...
0
votes
1answer
43 views
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 ...
0
votes
0answers
657 views
How do deal with SQL Server transaction log corruption
We had a failure with our SQL Server log shipping job. sp_readerrorlog reported:
Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF ...
3
votes
1answer
139 views
Transaction log backup size change
We are running six transaction log backups every day on our SQL Server with three hours gap for each succeeding pair. I have noticed the 'data size change' column of the transaction log backups on the ...
0
votes
2answers
450 views
Transaction log full issue with SQL Server 2008 R2
I am running into 'transaction log full' issue with SQL Server 2008 R2.
My database includes 80,000 tables which contains up to 5 columns of BIGINT and there is an index for each columns.
The ...
3
votes
2answers
2k views
How to shrink 40GB LOG file
I have a problem that is my log file in SQL Server 2008 is grown to 40Gb and I wanted to shrink it. The query I am using is
ALTER DATABASE DatabaseName SET RECOVERY SIMPLE
use DatabaseName
GO
...
1
vote
1answer
530 views
Event ID 7888 : Transaction Log for database is full
My application is running in the SharePoint Servevr 2007 environment, however I was encounter an error as below:
"A runtime exception was detected.
Details follow. Message: The
transaction ...
1
vote
2answers
232 views
Transaction log: Truncate vs. backup
I have a SAP ECC instance which runs on SQL Server 2000. The database is set up with the Full recovery model, but a transaction log backup is never done (not my choice). Instead, a full backup is ...
0
votes
3answers
1k views
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 ...
2
votes
2answers
138 views
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 ...
0
votes
2answers
129 views
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 ...
0
votes
2answers
240 views
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? ...
2
votes
2answers
218 views
How do I restore a SQL Server database from last night's full backup and the active transaction log file?
I have been told that it's good practise to keep your SQL Server data files and log files on physically separate disks, because it'll allow you to recover your data to the point of failure if the data ...
1
vote
4answers
298 views
Managing Log File in SQL Server 2008
These are my current settings:
Recovery mode: Simple
Logfile initial size: 10 mb
Logfile autogrowth: None
Database auto shrink: Off
The logfile autogrowth is set to None because I don't want the ...
1
vote
1answer
135 views
Setup secondary server for Transaction Log Shipping without connection to primary server
I'm having a hard time with SQL Transaction Log Shipping with the following premisses:
Server A, where data gets loaded to the database
Server B is on a remote location
The two servers never share ...
0
votes
4answers
163 views
0
votes
3answers
510 views
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 ...
2
votes
1answer
264 views
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 ...
0
votes
1answer
179 views
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 ...
7
votes
1answer
165 views
Does a failed full backup invalidate future transaction log backups?
I have a server running SQL Server 2005. I have nightly full backups, with transaction log backups every 15 minutes. This is a relatively small server so I am not doing any differential backups.
If ...
0
votes
1answer
268 views
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 ...
0
votes
3answers
586 views
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 ...
3
votes
2answers
678 views
SQL Server 2000, large transaction log, almost empty, performance issue?
For a company that I have been helping troubleshoot their database.
In SQL Server 2000, database is about 120 gig.
Something caused the transaction log to grow MUCH larger than normal to over 100 ...
1
vote
2answers
581 views
Transaction log shipping SQL Server 2005 to 2008
I have a reporting setup with SSRS on our SQL Server 2005 database. Because SQL Server 2008 is not supported by the main program which populates our database we are stuck with 2005 on our production ...
1
vote
3answers
3k views
How do I backup the transaction log for a mirrored database in SQL Server?
I have a mirrored database and am trying to perform a backup of the transaction log, but after it gets to 90% it just hangs and won't go any further.
What is the correct method for backing up a DB ...
3
votes
3answers
376 views
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 ...
3
votes
1answer
567 views
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 ...
2
votes
2answers
327 views
Software for browsing/searching SQL Server transaction logs
I'd like to know whether there is any piece of software that will allow the browsing/searching of SQL Server transaction logs (any version). We've previously used Lumigent Log Explorer against SQL ...
1
vote
3answers
2k views
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 ...
0
votes
4answers
351 views
Software to recover SQL Server 2005 ldf file
Can Anyone tell me how to recover database in SQL Server 2005 using free (i mean not shareware) software that only using ldf file?
Thanxs before
1
vote
2answers
87 views
Transaction Log a part of the server or database?
In practice (and in general) is a transaction log a part of the database server or is it a part of the database itself? I've not been able to locate information in this domain anywhere. I need the ...
0
votes
3answers
346 views
SQL Server rolling forward lots of transactions, what should I look at?
I am running SQL Server Express on a Windows XP Embedded box. It runs for a day or two, doing some transactional processing for a POS type system, and with another system pulling data out to an OLAP ...
0
votes
2answers
538 views
Transaction Log backup fails if no full backup exists
...at least I think so.
I recently revamped my backup routine on my development server. I created a maintenance plan for user databases that did some weekly cleanup tasks, daily full backups and ...
2
votes
3answers
981 views
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 ...
