I hope you mean not just restarting services. Whole physical box should be rebooted because SP3 updates Windows registries, it is important.

Yes, because you want to provide a seamless failover.

1. Connect remotely to the first node of cluster through the Terminal Services by physical box name

2. Copy installation package to the local drive

3. Install SP3

4. Reboot a box

5. Verify...

It is well known issue for SS6.5

Here is a solution:

http://support.microsoft.com/kb/285025

Ok, I see your problem.

The login was mapped to the database as the dbo, which is wrong. It happened because this account actually created a database during the installation.

Please...

Make sure you are running you statement against the right database.

Use this statement:

USE Adventureworks

GO

select object_id('person.document')

You are running your script against the master database, but you have to run it against your particular database.

Please do it and show the results.

Do you have a nightly restore of this particular database from another server?

If yes, you have to add this login to there.

Here is the answer:

Check users, mapped to the database - one of them mapped from your login.

Sometimes it is impossible to change database status, because it is corrupted.

Just make sure you don't have space issue and then re-run your job again - the new Restore on...

Other your weird issues probably related to the discrepancies of SQL Server versions on your servers (different services packs).

What do you mean "unsuccessful"?

Just click on "Jobs" node in the Object Explorer of SSMS, then highlight all...

As I said, just lock the file size and set growing rate to 0.

Look at this info about the best practices:

www.sqlmag.com/Article/ArticleID/39158/sql_server_39158.html

www.sqlservercentral.com/Forums/FindPost636220.aspx

Two more things.

There are many reasons for TempDB files grow, it depends on particular case. For instance you may have a procedure, which use temporary tables in a code.

If...

The single TempDB data file should be split to the number of files equal the number of CPUs on your server.

All of these files should have exactly the same initial...