.

Thanks Lynn.

Thanks a lot BrainDonor,

Can high CPU usage over 95% for hours will bring SQL Server down??

Thanks Gianluca & BrainDonor,

Its 'The wait operation timed out' error looged in our exception table and i believe its timeout experienced for customer when accessing the site.

had a high CPU...

Thanks a lot Grant.

When i pint over an item in Estimated execution plan(eg:Table valued function) i am getting the estimated number of executions =200?

What exactly this means and is this...

Thanks a lot Henrico

Thanks again

What my doubt is my old file is set autogrowth=none and we are facing error i mentioned above.

Now i have created a new file in another drive and set...

Thanks Henrico for the quick response.

That means whatever the value we provide during the creation is the value it can grow? right

Creating another file in same filegroup will resolve this...

We are taking fresh backup not appending to any existing one.

Can i recommed team to check the disk and IO subsystems? If yes could you please let me know what...

Thanks for the quick reply

We are runninng backup using litespeed. when took using sql native tool i select the checksum option .both litespoeed and native returned corrupted backups

GOt error when...

Thanks everyone for the reply.

Can anyone please clarify whether backup will cause performance degradation??

I think the update data will be shown only when database use those space. You have allocated the space but still db is not using that space.

Some application must be using that login with a wrong password.

When you started to get these errors?

Have to changed the password for that login in recent times?

Give the full path ie \\servername\c$\folder\backup.bak

Development team has done some changes ,not sure about that..

Could you please let me know what changes it can be?