thanks alzdba

What group rights would I need on each SQL Server machine in order to restore remotely from the .bak location ?

Since these reports would be logged daily, what are few methods of automatically generating a report that I can use to compare performance, job status, etc ?

I'd like to start off using a...

so here is something interesting (for a noob at least!)....

on 2 SQL Servers I have the same SQL roles : Security Admininstrator, Process Administrator, and I have 'TargetServers' role on msdb.

I...

Thanks Mohammed.

It would be great if there were a role to simply view maintenance tasks and histories and not have sysadmin control, but I'm not sure if that is at...

I'll rephrase my question as it may not be specific enough....

What server and/or database role will I need to analyze Database Maintenance Plans in SQL Server 2000 ?

currently I have...

Thanks Brian !

What would be an appropriate Server Role within SQL Server for me to monitor logins, maintenance plans, and check things like recovery models for each database ?

I only...

my apologies Brian

you can delete this topic if you'd like.

Thanks Mohammed

so if my domain login was added to the 'Performance Monitor User' group on the WinServer2003 machines, would I be able to remote connect to each SQL Server instance...

how can I be granted access to monitor through client access Enterprise Manager (from an XP machine) without disturbing the function of each SQL Server ? 

this is probably an annoyingly simple situation,...

Thanks for all the input.

Rudy, I havent been able to access the SQL Server in question, so I will have to wait a while before I can confirm the recovery...

Thank you very much Yelena.

I'll take a thorough look through those articles.

In the meantime, I was wondering if replication from the old NT box (limited resources) to the new W2003 box...