SQL Server logs Questions

1

Is it safe to delete SQL Server Transaction Log?
In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but [...]

Answer Question   |  November 18, 2010  11:59 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003
asked by:
10 pts.

Database Log File sql server 2005
We have a 500GB database, we use a san server with 16 drives. Eight drives are for storage and the other eight for mirroring. All eight drives is one RAID 10 and within that RAID 10 we partition the drives into 8 drives (please seee below) we are having so much slow performance on the [...]

Answer Question   |  August 10, 2010  4:35 PM
RAID, SQL Server 2005, SQL Server 2005 performance, SQL Server logs, SQL Server performance
asked by:
585 pts.

BACKUP in SQL SERVER
Hello Sir, Can u get me the answer  to this question Management wants the backups to be done daily. Transaction log backups must be every afternoon and morning and that you should keep in mind that the content of the log will get larger and larger. You also need to take measure to do the log file. [...]

Answer Question   |  May 7, 2010  6:21 AM
SQL Server backup, SQL Server logs
asked by:
135 pts.

Monitoring log files in a SQL Server 2000 database
I have an intermittent problem with a SQL Server 2000 database. The job, to truncate the log files, doesn’t start on time, and the transaction fills up preventing users from logging in. I would like to monitor the log such that I can send an alert when the log reaches e.g. 80% full.

Answer Question   |  February 24, 2010  9:18 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server database, SQL Server logs
2,585 pts.

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.

Answer Question   |  August 18, 2009  2:11 PM
SQL Server 2005, SQL Server backup, SQL Server log shipping, SQL Server logs, SQL Server transaction logs
asked by:
585 pts.

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?

Answer Question   |  July 15, 2009  2:52 PM
MDF, SQL Server database, SQL Server error messages, SQL Server errors, SQL Server logs
2,585 pts.

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?

Answer Question   |  April 17, 2009  5:14 PM
Oracle 9i, SQL queries, SQL Server logs
asked by:
5 pts.

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. Changing the database [...]

Answer Question   |  May 14, 2009  2:53 AM
70-432, SQL Server 2008, SQL Server logs, SQL Server transaction logs
asked by:
15 pts.

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?

Answer Question   |  November 7, 2008  3:39 PM
SQL Server backup and restore, SQL Server logs, SQL Server recovery
2,585 pts.

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 [...]

Answer Question   |  July 30, 2008  8:16 PM
SQL Server databases, SQL Server logs, Testing software
2,585 pts.

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?

Answer Question   |  November 4, 2008  9:02 PM
SQL Server 2000, SQL Server errors, SQL Server logs, SQL Server performance
asked by:
40 pts.

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 Date and [...]

Answer Question   |  July 15, 2008  11:01 PM
SQL Server, SQL Server logs, Temp Tables, Triggers, Unknown processes
asked by:
5 pts.

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 [...]

Answer Question   |  May 5, 2008  3:30 PM
SQL Server 2000, SQL Server logs, SQL Server performance tuning
asked by:
145 pts.

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 disabled by using DBCC command.. Still [...]

Answer Question   |  February 22, 2008  10:14 AM
SQL Server, SQL Server logs
asked by:
10 pts.

1