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
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
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
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
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
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
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
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
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
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
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
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
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
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