any one have idea on this

one more doubt can SSRS be configured on cluster server?

Thanks jeff

this is a some Human resources report which we cant modify. i'll try to implement your suggestion but not immediately.

4 or 5 days back it was working fine suddenly...

I have this script for SQL 2005 try this out

SELECT job.Name,

...

Why do you want to re initialise and increase manual load, if it is running fine already?

one more question why you rebuild or reorg (selective) job is running daily? is...

is this ''domain\xxxxx'' is your service account?

if it is are your sure it is Sysadmin in that server, looks like it doesn't have access to the DB as per the...

Full backup will not clear the log files. Full backup will take only the data backup.

Schedule for a log backup every "X" minutes and that "X" has to be...

Funny some times we face viceversa.

Have you confirmed that you are using the correct IP? Ping once and check.

was any other previous backup's running that time?

Thanks guys for your input

They have decided to keep 3 months data so we are planning to move the current 3 months data to new table and drop the existing...

I don't know much about it but our development team asked DBA's to run long back so i remembered it.

This link may be useful for you

http://www.codeproject.com/Articles/19954/Execute-NET-Code-under-SQL-Server-2005

Are you backing up SSIS packages thought...

In application are they closing the connections properly?.

As the above user indicates it wont harm your server when a new requests comes it will use the sleeping connection.

1 month

2. What is the format of the date in the INT column? Is...

yes i understand, how about a self made report with history details. i dont tink any such reader role available by default.