Yes, you can point the distributed playback mechanism to 2005. It just needs a database to connect to. But, the install is 2012, so you have to have that first.

The size of the index really depends on the size of the CHAR field and the size of the number field you're comparing. If the CHAR is CHAR(2) and you're...

The error you're getting, "This differential backup cannot be restored because the database has not been restored to the correct earlier state.", is usually indicative that the full backup and...

I'm not worried one way or another about an index on a CHAR column. However, storing numbers in string columns is very concerning. You're going to hit issues when you...

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.