The backup name shouldn't matter, it's the data in there. You need the logical names to "move" the files, but you should just restore this file as a database name...

You've got incorrect pathing, and the error is you're creating a folder that exists. There isn't error checking here on this, as the maintenance plans are very basic.

You don't want...

If you have the required horsepower, and I don't think it changed much for Express, I'd go with 2008. No reason to go with 2005, which will be out of...

I'd recommend Itziks' books. If they get too complicated, move to the next section, but he does a great job going over things.

I think source control is good, but if you have a lot of developers, it can be rather cumbercome and confusing. What I'd do is once they think they have...

First, maintenance plans and devices aren't related. They're different concepts. You can use devices with or without maintenance plans. Note I don't recommend devices. They're a hold over from older...

http://www.sqlservercentral.com/articles/Administration/2733/

For 2 rows, or 10, or maybe 100, it will scan. It's not worth the effort to scan an index and then go get the data from the table. A...

It can help if there's an index, but not sure that it would help on an index column.

Is there a stop/start in 2005 as there was in 2000? Don't see one, and I think that each time you call the XP, it logs on, doesn't keep a...

I edited your post so it wouldn't require so much scrolling.

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

sp_configure changes options. OR you can use SSMS and right click the server, properties, adjust the values there.

I don't think so, but you might need a restart of dbmail. Haven't tested this in 2005 and no Exchange server (or 2) to try with.

Planning and initial development of SQL 11 is going on. I'd file these on Connect (connect.microsoft.com) and get this in front of those people that will do the design. I...

I agree with Glen, this sounds like client tool corruption.

Are things still running, meaning do you see lots of disk IO taking place? I think it could run long, and yes, you're lose the work.

If you have enterprise, you...