How you got the values 2.8Mbps & 200Kbps??

Thanks Perry

Thanks Donor:-D

you sure you have enough space on disk those days?

Shrinkfile is not recommended and after repeated attempts its not shrinking means SQL server is using it or need that much space.

To which location you moved the files?? Are they the same location where tempdb files resides?

After moving to the new location are you sure you have sufficient space under that...

Do you have that much tempdb operations happening to use 2GB?? If not try reducing the size of tempdb files and see how SQL Server behaves..

SQLSACT (9/26/2012)

---

GilaMonster (9/26/2012)

---

Maybe, but maybe not. Older pages may still get tossed out.

Unless you have buffer pool > total size of all DBs in use, you can't assume that there...

TimParker (9/26/2012)

---

We have 2 SQL servers here at work. Both "appear" to be configured the same. But when I look at Task manager I see that one of them is...

Thanks a lot Gail

Hi Gail,

Thanks for the reply. Can you please be more elaborate?

As far as i know chunks less than 64MB...

Its not recommended to shrink the files as its cause fragmentation as already posted by experts earlier

You can use DBCC SHRINKFILE to achieve the same

Experts,

If i have a 10 MB log file and if i add 40 MB will it create a total of 4+4 VLF or will it accomodate the new 40MB to...

Suresh B. (8/9/2012)

---

Rollback happens in the memory and pages becomes dirty again.

Those in disk will be rollbacked to memory .Am i...

No error on SQL error log and found hte same error in windows log.

Master DB backup completed without any error.