Thanks for your inputs everyone. I'm currently testing mirroring to see how it will work for us.

As far as where I read that log shipping will be...

Thanks Matt.

I just looked into log shipping, but I read that it is being phased out in the future releases of SQL Server. I'm currently looking into mirroring, which...

No you don't need to enable it. SQL Server 2005 is able to make use of all of the memory.

Hi Matt,

What we want to do is have a copy of our databases in SF in case there is some emergency in LA. We have a window of 1...

Would this scenario work?

Replicate from Server A to Server B locally. Detach the replicated database and send it to the remote office and set up replication there?...

Thanks Chris,

I really miss that feature.

Thanks a lot!

Or if there is a way to get the package into the Business Intelligence Development Studio application, please let me know. I'm supposed to finish this project today, and...

Thank you Carl!

Thank you, I'll create scripts since we only have about a dozen jobs.

Thanks for your response.

Once I move to 2005, I won't have access to the 2000 databases. Is there a way to save the jobs and import them to 2005...

Yes, I have tried that. When I run xp_logininfo, I get:

account name ...

Sorry for the very late response. The user tried to connect to the database using QA and he gets the same error message.

Hi everyone,

My user is using a domain account. The server is in the same domain too. The server is set to mixed mode auth.

There are other...

Thank you very much for your detailed response.

As far as DTS packages go, we have hundreds! What kind of...