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...
View Answer
| Jul 22 2008 8:16 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server logs, SQL Server databases, Testing software
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?
View Answer
| Jul 18 2008 9:02 PM GMT
| asked by
Ftornoe
SQL Server 2000, SQL Server errors, SQL Server logs
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...
View Answer
| Jul 14 2008 11:01 PM GMT
| asked by
Mjf7
SQL Server, Triggers, Unknown processes
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...
View Answer
| May 2 2008 3:30 PM GMT
| asked by
Ellie
SQL Server 2000, SQL Server performance tuning, SQL Server logs
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...
View Answer
| Jan 20 2008 10:14 AM GMT
| asked by
19091981
SQL Server, SQL Server logs
