Good ideas..I'm a DBA who is just beginning to dive into SSIS, so the response is much appreciated. I'll give those a try. It still perplexes me as...

File versions are tracked, yes.

Also, these files will be continously checked out and edited - similar to a SharePoint repository.

Thanks for the reply. However, doesn't storing blobs under 256k in the database perform better than storing them on the filesystem as you're suggesting?

The files will be accessed often - this application is basically a document repository. I'm beginning to think a hybrid apporach would be best as well.

Problem solved. I've done some reading, and it seems that no matter what you change the default backup directory to when you do the install, the GUI attemps to...

Thanks for the replies everyone. I'm unable to remote into the node as the service account as that login was not given remote desktop privileges, I'll see if I...

The service has both - it is part of a local group on the machine that the rest of the sql server services are part of(both 2005 and 2008). ...

SRS 2008 is configured to point at a remote instance, and the port for that instance is opended on the server where it's hosted..any other ideas?

Awesome, I had stumbled across that setting and had a feeling it had something to do with it, but wanted to wait until someone replied to verify my thoughts. ...

I believe it was because when you go through the GUI, if the stats have not been updated recently, there will be a difference shown. This table was updated...

Yes, I realized that. I did a select count(*) and the correct number was returned. Thanks for the response!

Aren't there other processes for RS that generate a job named with a GUID? Is there anyway to catch all these jobs in a view rather than just the...

Update the database you're replicating at the distributor and the changes should be push or pulled - depending on which you selected - to the subscribers. Replication takes care...