Are you not doing a P2V conversion?

Moving to a virtual server is no different than moving to a new physical server. The underlying architecture doesn't really matter to SQL Server....

You don't have failed backups, you have failed jobs. The backup is what is being run, and there will be some data in the job history tables, but the job...

http://msdn.microsoft.com/en-us/library/ms174397.aspx

Start slow Wayne. When I started running every day, I was in decent shape, but concerned about my knees. I went slow, and low, for about 6 months. I kept...

I think Facebook is great. It's a great way to keep in touch with people, see what they are doing, catch pictures, etc. It's an abstraction layer I like, and...

Just came back from a neighborhood meeting. Now I need to go shovel more manure around in my barn.

Does anyone have a fork I can stick in my eye?

Brandie Tarvin (1/5/2011)

---

Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for...

I would not make those 12 a clustered index. These 12 columns will be in every single nonclustered index as well, so they will all be wide.

I would lean towards...

Feel free. Looking for a nice short concise reference to give people, and use as a link in one of my talks 😉

If this is for school/homework, you should be working through some of this yourself. The scenarios you present are not that difficult, and some experimentation should help you.

If this is...

Since Red Gate Software (my employer) makes a product called "SQL Backup", I'd go with native/litespeed as the naming for the backup type.

Ultimately I don't think it's critical to know...

You should be able to move your partitioned table to a new filegroup by moving the clustered index (http://msdn.microsoft.com/en-us/library/ms175905%28SQL.90%29.aspx)

I like the idea of moving this to a separate filegroup, and...

Tony Savoie (1/5/2011)

---

Interesting topic. Never had the misfortune of going through anything like this so am looking forward to some insight.

"Database administrators often disable transaction logs for fear of affecting...

Apologies, apparently something broke over the holidays. I'll get someone to look at this ASAP.

I think Ben has some good advice here. I don't know that those two versions conflict anywhere, but the client version is what really matters. The server drivers matter at...