I would agree completely that LiteSpeed is a mature enough product for a production environment.  In fact, my testing is geared towards use in a production environment.  I would not...

We've done some consolidation in our shop (also insurance company!).  We have one consolidated server with databases supporting 13 different applications (small compared to what you're talking about!)  It has...

HIPAA requirements do require that any personal identifying private health information be protected on a need to know basis.  This would mean that even within your organization, there are those...

Jason, In all fairness, you should state that Red Gate's SQL Backup was recently purchased from Yohz Software, and VERY recently went on the market.  Of course they don't have the...

LiteSpeed does have functionality that is not included in Red Gate SQL Backup.  More compression levels, multiple encryption methods, backup to tape (though I haven't tested this), and maybe some...

The first issue that occurs to me in your situation, using a single database, is that the database will have different structures depending on the applications the customer wants.  That,...

In SQL 7.0, the log shrink does not happen immediately, and it can only shrink to the first "virtual log file" which is in use.  I'm including a stored procedure...

Sounds like a call to Idera Customer Support is in order.  I'd be interested in hearing the resolution, though.  I'm currently testing SQL Safe, and we're considering purchasing.

Steve

Also, in Enterprise Manager, Task Pad view, Table Info, you can see the estimated (from sysindexes) size in KB.

Steve

1. Try DBCC Shrinkfile to reduce the size of the log.  The method you are using is DANGEROUS!

2. The default location for the log files is apparently set to the...

Its interesting.  I saw this exact same question just a day or so ago.  The reason is that your date column isn't a date column.  Its a datetime column. '05/07/2005'...

As mentioned in the other thread, import/export may not copy your keys and constraints.  But backup/restore will.  If you can't see them, be absolutely sure that your restore worked and...

It sounds as though the transaction never made it to the database.  You can't restore something that never existed.

Steve

If you're going to try this, it is extremely important not to write anything to the disk that the database files were on.  If the files were on the c:\...

Its almost certainly a problem with Enterprise Manager.  I've seen it more than once, and reinstalling Enterprise Manager (the client tools) fixes the problem.  Can't guarantee it, but I'd be...