What's your client? How are you thinking to pull them? The client app gets a path and ????

I think an HTTP request from an internal or external IIS server is...

Well, I know the editor, so I got to schedule my thoughts early 😉

That's a good summary of some issues. And it covers some of how I feel as someone...

I tend to agree with Richard. While for performance reasons it's shown that in the db at these sizes is quicker than having things served off the db filesystem (with...

If you are wanting someone with more knowledge than you, good luck. Jason is probably right, but I think you'll struggle to find someone to move to the islands that's...

Can you not script (with VBScript/Powershell/SMO) something that runs a backup for the client and uploads/emails the bak?

Very cool, Lowell. Certainly easier than scripts to start with.

No, but Sybase uses T-SQL, so there will be some familiarity with the language and syntax. Thats' about it.

What do you mean "open a URL"? When you put a URL in your browser, it gets a stream of HTML that it renders. What do you propose the server...

Litespeed doesn't change the fact the server is doing the backup.

You are going to be copying data from a location the server can see to the client's disk. That can...

The default trace keeps a certain amount of data. It's not based on time, but does it matter? Try it and see if the data is there.

The only other alternative,...

Jeff was a little short after your reply, but how is this rude?

Nice try on the posted data... for future posts and better/quicker answers, plsea see the article at the...

You can try the default trace, and see if it's still in there. http://www.sqlservercentral.com/articles/64547/

otherwise, no. You need to be looking for this activity with a trace to catch it.

I thought SSMS would be great when I first saw it, but it's too fragmented for me.

The thing I've found is that I don't often keep jumping to different tasks....

Typically to find the latest, I've used a correlated subquery.

select a.SalesDate as 'MostRecentDate'

from Sales a

where a.SalesDate = (select max( SalesDate)

...

I agree with Henry. The log in simple mode grows to accomodate the largest transaction that is open. Then once the transaction commits, that space gets re-used. If the log...