I believe I am having the same problem. We have a SQL 2005 cluster that I can't create a linked server to a SQL 2000 server off site, however...

Actually, I probably need to explain the snapshots on the mirrored database. They are scheduled every hour and normally take 2-3 seconds to complete--even on a very busy database....

I was thinking that maybe the virus scans were scanning the data folder where the mirrored database and snapshot live. The scans were stopped yesterday so I'm waiting to...

We have almost the same situation. We have a cluster on x64 with 32 GB memory and I have SQL Server capped at 26 GB. Our server team...

Thank you. I had tried the Oracle 9i driver which is supposed to be for 32- & 64-bit servers, but it didn't work. I've heard that others have...

Thanks for the info. I'll give this a try. I haven't had much time to experiment because the servers had to go into production quickly. It looks...

Great feedback. Thank you all. I also should mention that the application they intend to use needs to be a sysadmin on all of the database servers. ...

We were thinking of using mirroring instead of clustering for high availability but were unable to because the client application can't use the SQL Native Client to connect. Since...

I haven't tried creating an SSIS package on our Windows 2003 x64 server using Oracle 8 or 9i driver, but I kow that linked servers won't work. The 64-bit...

Actually, I've done both (upgrading a cluster in place and moving to a new cluster. Our servers were going off lease so I installed SQL 2005 on the new...

I don't quite understand why the snapshot has to reserve the space but it doesn't use all that it reserves. On the snapshot file click properties and look at...

Actually, you may want to try creating a linked server and see if you get the same error. I scripted a linked server and got the message "The OLE...

That's what I thought as well but wasn't sure. I may get the opportunity to run a few tests to confirm. Thank you.

Yes, I am very familiar with log shipping and have tested mirroring a number of times, but thanks for the reminder 🙂 Since both are initially set up with...

I have to reply to this post. Yes, I am tired of poorly built 3rd party applications too. For years our IT department didn't have any say in...