If you are using SQL 2000, you could take a look at SQL LiteSpeed.  It is a backup product that uses compression and is supposed to be able to be...

Let me add that INDEXDEFRAG + UPDATE STATS creates even larger transaction logs than reindexing.  We use log shipping and have tried both, but need to stick with the defrag. ...

You will need to take the database out of read-only mode, add the user & permissions, then put it back in read-only mode.  Don't do this if the database is...

We only installed the client on a regular server, not a cluster, but had no problems with SQL Server and Pervasive.  I don't know how Pervasive will affect Clustering--if at...

I always hated those 7399 errors--in BOL they refer to Access databases which is not the case using an Oracle driver 🙂  Anyway, we got the same error on several servers...

You can install the Pervasive client on a SQL database server.  We did it on Windows 2000 with SQL 2000 and installed a Pervasive 2000 client and it was fine.  Can't recall if...

Another thing you might try is a different driver.  I normally end up connecting to Oracle databases using "Other (ODBC Data Source)" or "Microsoft ODBC Driver for Oracle".  Never had much luck...

I'd go to Control Panel, Add or Remove Programs and select Change for Microsoft SQL Server 2005.  Then you can go into each component you want to check and add...

I went to the link and it is no longer good since SQL 2005 Reporting Services is out.  The link to get the CD for 2000 is http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx.  Did...

Was the IP address changed?  We got the same errors after changing the IP on a SQL cluster even after using KB 244980.  We had to manually clean up the...

I need something that doesn't add tables or triggers to the database being audited.  I prefer something that doesn't use trace procedures due to performance, but would consider it.  The main...

How does SQL Data Compare work?  Does it use triggers, add tables to the databases, read transaction logs, use trace procedures....  I'm concerned with performance and not adding anything to...

What were your results with testing DBGhost?  Did you like the product?  We're looking at solutions too....

We're also looking for an auditing application because running Profiler adds too much overhead.  I found Apex SQL Audit and have downloaded it, but haven't done any testing.  I also haven't...

I can confirm that changing the standby database back to normal mode will definitely break log shipping.  I've tried it 🙂  You'd have to set up log shipping again from scratch.