drive letters don't need to match. Use the WITH MOVE syntax for restore.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Oracle Schmoracle. Hopfully they'll implode themselves!!!!

But some good suggestions. I still think the best bang/buck is SQL Server, ease of use, tools, etc. But for sure there...

The client tools are not installed correctly. HAve you updated them with a hotfix or sp lately? Might try repairing them or reinstalling them.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

It seems you are confusing memory with disk space. Both will help with analysis services.

How much memory is on the server and how much disk space (used and free)/

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Apologies. The search has been a tough topic for us, trying to handle the different cases and the rapid growth of the site.

We bought some search engine, the name escapes...

http://www.sqlservercentral.com/columnists/sjones/gettingyourserverinformation.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

I don't think there is a way to do this. Autoclose might work, but it will reopen if anyone accessses it. I think using the backup to disk is the...

Asfar as I know, there is no way to do this.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

The DTS task only downloads files, it doesn't upload them.

I've got a script that can help you to put things out there.

http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Thanks for the followup. I suspect that the 2nd page actually deletes the cookie.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Hard to tell. Have you run the same queries in Query Analyzer?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

I would hope so. Don't have any non production SP2 boxes I can test it on, but I'd beware if you are installing this hotfix.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Did that help?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

We are using the old Snitz login technology which works with cookies. I suspect there is some issue here. If you delete your cookie, does it log you out?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

You should be logging the results somewhere. Check the maint plan to see where teh logs are written and then check the text file for the plan. You will probably...