SQL Server Logs

SQL Server Transaction Logs

If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that. Software/Hardware used: SQL Server 2005

SQL Server error: Cannot find log file

I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

log sql queries?

queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?

Transaction log for read only database...

Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims "when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database....

Restoring to the end of a log backup in SQL Server bulk-logged recovery mode

In bulk-logged recovery mode in SQL Server, how can you restore to the end of a log backup that includes a bulk event? It seems to me that everything after the bulk event is useless. How could I do this?

Implementing a test system with SQL Server log files

We need to implement a test system where the entries created in various tables on a test server need to be automatically re-generated on a live server so that there are no manual errors. We think the only way to do this is to use SQL Server log files. However, we are not sure that the tools...

SQL Server 2000 error in log: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.

I am seeing this error weekly in the sql server log with associated performance hit: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch. Has anyone resolved this error?

How to find out what is happening in a Database?

We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database's tables. All I can report is that an insert, update or delete has occurred, the...

DB size

Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space. Anyone has any idea how to shrink the DBs or do something to reduce the size. The LDFs...

SQL Server transaction log problem

An error like" Transaction log full.. backup thelog and shrink the database .. " occured.. Many times the transaction log was backed up and shrinked.. Niow a stage has come where even doing the phenominal process.. the error still re occuring.. Afetr going thru a website transaction log was...