Just to provide a couple of comparison times ...

HP-DL-580 quad 3.0 Gh Xeon CPU, RAID 1 OS, separate RAID 5 SAN arrays for data, log and backup. Restore time for...

I try to keep the total size of a transaction log to 10-20% of the total database data size for starters and hourly transaction log backups. Then based on log...

You don't mention whether the application is home-grown or a vendor supplied package ? If it's a vendor suplied package have you tried to contact their helpdesk line posing the...

If you have the extra cash (possibly 1-2 K), look into upgrading to SQL2K Enterprise from sStandard. Enterprise has built in log shipping functionality which sounds like a tailor made fit...

There may be 2 issues here. First I'd go back to BOL and check out everything I could on transaction logging. If recoverabilty is not an issue then 'Simple' is...

For logins check out this link: http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

You might want to look into the sysprocesses table ... there are a few columns present (if the application connection string populates them) that might make this a snap.

We have several vendor applications that issue similar messages for login failures (as opposed to' 42000 login failed', the norm). To diagnose these we've have to extract the user/password from...

As a part of a standard SQL server installation/configuration we always set the size and growth attributes of the master, msdb and tempdb databases. By doing this initially we've avoided...

5 platforms in all:

WIndows XP --> for the kids

NT 4.0 Server -->  SCSI II, RAID 5, SQL v7.0, Sybase ASE v12, Oracle v8, old work box (soon to be Win 2K3...

245 columns in one table ?!?!? Well maybe a shot a normalization (breaking things up into a few tables) just might be in order. Not attempting to do this might well be...

I'd run perfmon on the pagefile, memory,  and maybe processes before even thinking about changing anything.

Just a few brief thoughts shooting from the hip:

1) is the MDAC up to date ?

2) up the memory to 256 Mb (256 Mb is plenty for windows with MSDE...

Since this v6.5, the first 2 Mb of tempdb by default are on the master device. Based on how large you want to grow it you will have to add...

If it's only 2 machines it does not sound like an issue. If you have SMS available that makes life much easier. Just create a package, advertise it and you're...