Thanks

This is a archived database and data is viewed via a managed solution. Budget is not an issue

Thanks for your response but i am not worried about giving access through AD group.

My question is how much CPU, Disk etc is required so that users can access the...

thank you all for your responses.

We use Litespeed backup SP to backup databases changing @thread from 1 to 2 has reduced backup time by half it took only four hours...

I'd my Development team having issues with performance after restoring a db from production with one particular procedure .

They were all thinking it might be index issues .After analysing, capturing...

Thanks. Actually i've three named instances on a cluster but with different dynamic port numbers and each earrolog have two diffrent ports.

I tried all of them but none of them...

SQL server is on Cluster only two port entries are available in the errorlog. 2932 i think for dedicated administrator can't connect using this port.

tried connecting 'server/instance,5678' but failed with error.

Even tried 'IP,5678' but no luck yet

Thanks! it's a third party database.

Thanks again for all your help with this.

I think this is what you're after

http://www.sqlbackuprestore.com/backuprestorehistorytables.htm

All transaction log backups taken after the full database backup should be restored . Log backups running prior /while full database backups should be ignored.If you try to restore them...

yes, its a user defined proc defined in User database but name starts with sp_proc.

Login's deafult database is 'Master' not user defined database where SP is

Backups must be restored in the order in which they were created. Before you can restore a particular transaction log backup, you must first restore the following previous backups without...

Thank you all for the vaulable inputs.

Thanks, adding events will have any impact on server perfromance at all?