Hi Satya, Well, that's the real problem...there aren't ANY full backups. Apparently my client has had this issue for long enough so that the tapes...
All, I'd love some thoughts on this topic, if anyone knows. Here is the situation I'm trying to resolve: The problem is that the database has been...
I've got an instance of high-performance mirroring setup, but I need to make some schema changes to the principal database. I can't find any...
Why would either column already be unique?? If these are foreign keys, that would not be so. I make composite primary keys from multiple...
There are a few command line parameters for basic config, and then there is an optional configuration file where you can really tweak it. I was...
I've had a similar situation where the I/O subsystem was just not working correctly, and kept corrupting the databases. The hardware guys assured...
It sounds like your transaction log is getting corrupted. Have you checked the disk and I/O subsystem for hardware issues? You might have to...
Yes, this is on SQL 2005.
Both good points. I will do some further investigation into optimization tasks that may be running. My understanding of sp_refreshview is that it...
Databases around the world declining into a state of neglect because of this thread. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
All, We have a view that, while not very complicated, does access two different databases on the same SQL server instance. Every Monday morning,...
Here is Microsoft's description and feature comparison: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Developer edition is...
We are running mirroring with no witness, in high-performace mode. This is how we do it: When you bring the primary back on line, it should return...
So, you're talking about intercepting the PDF generation, making some formatting changes, and then producing the PDF? I'm not even sure if that's...
According to BOL, no: "All mirroring connections on a server instance use a single database mirroring endpoint. " Just curious, why? -Greg
Separate names with a comma.
