You could automate some type of restore for the logs based on timing, but I'd tend to do it manually. Be sure you are naming logs with some type of...

Use the old syntax

Select TableA.Col1, TableB.ColA

FROM TableA, Table B

WHERE TableA.ID = 1

AND TableB.ID = 2

What about custom VB/VB.NET/C# apps? Does the binary need to be compiled specially for 64-bit? On a 64-bit workstation or is there another version of these products?

Is there anything else in the Windows error log?

Have you tried a different path/filename to be sure there's not something wrong with that file?

Haven't decoded it as it's a bit long

If you know that is the weak section, I'd break apart the query from the union...

Maybe move the ActiveX task to after the export and "reformat" the sheets?

They work well as a PK, but that doesn't mean that you shouldn't be looking for a natural key in the data. Dont' make them a clustered index and be...

No idea if transactions are suspended, but I don't think so. Haven't seen significant slowdowns during log backups.

The start would be the last checkpoint if there are no active transactions,...

Backup is at point of time it is started. If you make a change while the backup is running, the pages that need to be changed will be grabbed and...

Martin has a good situation there. It's mainly for events that aren't regular, some non-standard event that causes an unusual growth, such as a data load.

Used to run BMC's Patrol. Worked ok, very expensive, not sure I liked it.

When I managed DB2 guys, they swore by Spotlight and used it all the time.

1 and 2 - sysdepends. It can be out of date, but Red Gate software has a tool to help you determine this.

3 - you can search in syscomments for...

Once you get 4GB, you can just let SQL run. I never see it run above 1.8GB.

I'd give it at least that much and you should be better off.

Sorry, I have no idea. I was in the corporate side of things and so didn't work with movement of the product. Plus we never looked at migrating anything off...

In SQL Server 2000 or 2005?