To update the internal servername you need to do this:

sp_dropserver 'oldname'

sp_addserver 'newservername', 'LOCAL'

Once you do this, bounce SQLServer to make it take effect and run...

You probably should open a ticket with Microsoft about renaming a cluster. You could open up a whole can or worms on that one. If you have the...

Did you hear this one:

Dominican Police: Carmona Using Assumed Name

By Ben Nicholson-Smith [January 20 at 1:54pm CST]

FRIDAY: Carmona was released from court in the Dominican and asked for the forgiveness...

Here is the latest on Prince F.

Prince Fielder: Monday

By Ben Nicholson-Smith [January 23 at 10:47am CST]

It's hard to imagine that anything's holding back the market for Prince Fielder...

I have done this twice, the last time was applying SP3 this past Sunday to sql2008 active/active cluster.

My situation, WIn2008/SQL2008 Cluster default instance and INST2 instance.

WHen you go...

Some one or some ID that has 'sa' rights is about the only thing that can change it really.

I thought about that but this is a one job only type deal. This person owns this job and simply wants to know when this job finishes and how...

OK, so what is your question specifically.

You have some code somewhere that ran in SQL2000 mode but it doesn't in SQL2008 mode.

To be safer even still I'd run the Update Stats routine after you change compatability.

If you have the master,model,msdb and user databases in the DATA folder and SQL Server is installed in the same drive/path.. .then yes. You stop the service and copy...

The jobs and such are stored in MSDB.

The way I have done it... because I have simple installations....

Script out the jobs and then import them to MSDB. Done!

as far...

I have used dns aliases for ours... not SQL Server aliases. It should work the same but you'd have to test it out.

If SQL Server is all installed EXACTLY...

What I was talking about was creating a dns alias on the Windows network domain... not a SQL Server created alias.....

Are they the same version of Windows, same version of SQL Server with the same drive letters/sizes and installed to the exact same paths?

I know EXACTLY what your backup problem is. You need to have [dbname] around the db name due to the characters in the database name. If a dash...