That solution assumes the backup is named the same thing. In EdA's position he will not know what the backup is called...

Uh, oh. This is beyond what I know. I am reading MSDN's SQL Server Online Books - Surface Area Configuation, but, I observe caution in new areas that may cause...

Option I have considered (although never implemented at current employer) is after each backup job runs have it generate the restore script. If you did something like this you...

How are you grabbing that backpup file name now to restore from?

Your initial post stated the job was run at 7pm to restore hte 6pm backup from prod...

If you logon to the node as the SQL service account can you access the network share and read/write to the directory where the backups are?

As Sudeepta stated AD groups is the best control method for access, especially once you get a high number of users.

Edit: I have worked with applications that used the .NET...

I'm happy that you have data in a table...:hehe:

What is your specific question/problem?

As magasvs stated, a little bit more information is needed before suggestions or advice can be given.

What OS edition and 32 or 64 bit?

What SQL Edition (Enterprise, Standard,...

All ideas given are good, but I would agree more with PaulB's idea. I'm not sure what auditing requirements you have, maybe company policy or dictated by industry standards...

If the SQL Server 2000 instance still exist or is accessible, simply copy the job over to the SQL Server 2005 instance.

First...tell you colleague not to kill a backup :w00t:

If you check Activity Monitor or query sp_who/sp_who2 what wait-type does it show for the rollback process?

Premo number 1-O:

It must be the database!

The Standard Template should get you what you want. Although it is better practice to use a server-side trace for performance purposes.

Which is pretty easy to setup. Quick...

Since it is just the Tools, I would probably not mess with the registry hive. I would suggest trying:

1) Remove SSMS and desktop tools for SQL 2008 R2

2) repair/reinstall...

Have you checked the CUs released so far for SQL 2008 R2. June 23 the CU #2 was released but I have not gone through the details of those.

Also,...