My principal and standby machine has SP3 but the witness has SP2.

Regards

IC

Thanks for this. The app is situated on another box.

Do I have to restart the machine after I set the memory to 6GB?

Regards

IC

Hi All,

Came across a very interesting article that might help you.

http://www.computationpress.com/images/sql_disk_001_10a.pdf

Regards

IC

Thanks to all for ur help.

All ur advice and articles given, really helped with understanding the problem.

Cheers

IC

max memory: 2GB

yes, i did use Task Manager, but i also used perfmon. I selected the page life expentency option under SQL Server: Buffer Manager. The result was 100 secs...

Thanks alot!

found a solution.

Detach and attach the database and the run the dbcc shrinkfile and Viola, space regained.

Please note that there are no Maintenance plans on the database...and all filegroups are enabled and data is being written to all files.

Please note the error as this is the...

4 filegroups exist on the database

I have tried shrinking the file...and I get the error that i posted above.

Hi there,

Found whats causing the error. There is a user email account that does not exist anymore.

Regards

IC

Do I check this under Services on Control Panel? What specific am I looking for.

Hi there,

What should I do to fix this? Both the backup and restore folders are shared.

Thanks. I have created the stored proc that sends the mail.

Thanks..i already know that....i have always done it manually...i ran the script below and it basically solved the problem:

sp_change_users_login