The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
262 views

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 ...
2
votes
3answers
94 views

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 ...
0
votes
1answer
469 views

SQL Server 2008R2 Transaction Replication Stop and Restart but continue log backups

In a database that is currently being replicated I want to stop the replication (stop the log reader process) for a period of time though I want to continue to take log backups on that same database. ...
1
vote
0answers
145 views

state_desc field in sys.databases Seems to incorrectly report “ONLINE” when it's still in recovery

Is it normal that select state_desc from sys.databases where name='mydbname' reports ONLINE instead of recovering? The database is not accessible and Recovery is still at 24% according to the ...
1
vote
1answer
205 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
980 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
1k 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 ...
4
votes
1answer
1k 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
2answers
628 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
898 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
110 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
1k 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
298 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
397 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
2k 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
133 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
657 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
168 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
61 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 ...
3
votes
3answers
917 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
53 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 ...
1
vote
0answers
1k 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
149 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 ...
1
vote
2answers
842 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
8k 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
866 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
281 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
6k 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
161 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
140 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
652 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
313 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
333 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
178 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
194 views

Shrinking Transaction log?

Why it is not recommended to shrink transaction log?
0
votes
3answers
732 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
361 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
251 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
195 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
411 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
758 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
797 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
665 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
4k 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
409 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
605 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
558 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
365 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
90 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 ...