Maybe I misunderstood, you're trying to apply the same differential that is matched to the first backup to a second, different backup? You can't do that. Differentials are tied directly...

Just a side note. Be careful about how you think about log backups. They're not done to maintain the log size or shrink logs or anything like they. Log backups...

Will you absolutely have IO issues? No one can say based on the information provided. Are you more likely to have IO issues having data & log on the same...

Take a look at the first operator in the execution plan and look at it's properties. Is the reason for early termination "Good enough plan found"? Then the optimizer did...

Any time you have licensing and pricing questions, you're best source is Microsoft. But, in all the conversations I've had with them about this, my understanding is, if you have...

naga.rohitkumar (8/17/2012)

---

I have to do my self but what is the process if a new drive is allocated for backups and datafiles how to move datafiles and backups into new...

There's not enough information here to give you a step-by-step action plan to handle database growth. I don't see the indications for how fast the database is growing. There's no...

That's interesting. I didn't know SQLIO was gone. Hmmm... Maybe they just renamed it. It never should have been called SQLIO in the first place, just IO. It never tested...

Doubly important not to switch to simple recovery because you're already potentially in a position where you may have an issue and might need to recover the database to a...

SSRS is almost a completely different field of study from being a DBA, so, while I like SSRS, support it's use and all that, I don't know that I'd concentrate...

And don't forget spatial data. That's a huge bit of functionality introduced in 2008.

Drop does exactly what it says. It's going to drop the existing index and then rebuild it. No, it won't leave the existing index available while it does the rebuild......

And make sure your backups have been running for the last several days. Make a copy of the backups. If you have log backups prior to the error, make sure...

Index intersection might work with the 2 indexes, but it might not. If not, you could try the same two indexes and then use a UNION ALL query to put...

asranantha (8/16/2012)

---

how can u gues it is interview question? and in case of its interview question why ur not help?ok if u know answer tell me answers its help other...