Kurt,

Glad you figured it out, thanks for the update and glad we could help.

Gotta double check those network admins 🙂

A Believer!!!

I agree with Clifton completely. wait for 2008 if you can.

Be sure you have enabled the DAC from the SQL Server configuration and do it from the local console.

If you're inclined, you can switch the angled brackets to & lt ; and & gt ; (remove the spaces )

Scott,

Thanks and I'll add this to the list. Probably a low priority, but it does make some sense to see the number of votes as well as the rating.

Steve

Nice one Hugo. I like it!

You may, but the question was just on part of the redirection. We try to get the questions tightly focused on one area, not necessarily on the whole process.

My bad. Not used to the new categorization system.

I'll fix that.

Make sure your server has an SPN in Active Directory. Be sure the times between the SQL Server the DCs are not off.

I'm not sure, but I could see that a quota on the file server could be causing issues.

Backing up to network drives is not recommended. The SQL backup program is...

A log reader will let you "undo" transactions, basically by adding reversing transactions and let you recover back to some point in time. You'll have to "undo" everything back to...

Think of a backup set as essentially a file. You can overwrite, meaning essentially delete and recreate the file. Or you can append, which means add a second set of...

Also, can you connect with the dedicated Admin connection from the local console?

What do you mean by optimize? You need to have some sort of idea of what you're trying to achieve in order to begin. There isn't any general way of...

I've seen a few of these demos, but they're mainly for SQL Server 2008, which has the spatial datatypes for geography.

You might be able to do it with 2005, but...