Looks like a bug. I'd report this to PSS. I'll ping some people, but not sure if they'll respond.

Use the above advice to restore the db.

You could remove, or uninstall, the default instance, but you might run into issues. They should be separate, but you never know. If...

Ahh, my fault.

Please send me a note (PM or email, sjones at sqlservercentral.com) with the old and new and I'll switch it. I was kind of expecting this to get...

John,

Thanks and can you let me know which browser, OS, Office versions? I'll pass along to the developers.

1GB will run SQL. It all depends on load. I'd still expect a buffer cache ratio above 0, might be 10, but 0 doesn't make sense.

Are clients connecting now? They shouldn't be if they're using server name. If they're using IP, it should work.

There are some products that can restore a single object, but they'll pull back the data for that object.

Otherwise if you just want the objects, no data, then I'd use...

Space is row length * rows.

So you can work out the max for a row, but it doesn't give you space used by a table. There are other scripts that...

There are quite a few things that you can't do in Enterprise Manager against 2005 servers. You'll need to move to SSMS.

There's a facility for running DTS packages in 2005....

First, please don't post in all CAPS.

There's no easy way to explain this. The query optimizer runs through a number of plans and tries to guess which indexes or joins...

I took that series (431, 441, 443, 444) and I thought 431 was the hardest. There were a lot of configuration and admin type questions, which I thought were nit...

Bottom line is you can. You won't hurt the database server or data, but users might have app issues.

We have these set up as redirects for tracking purposes. It helps us to go back and see which links are popular.

We've included the source from which the link comes,...

Go with R10 if you can afford it. Separate logs and data.

nope. This is a major shortfall of maintenance plans.

I've used scripts instead to power backups. It's easy to find some on this site or others, which will scan for non-system...