The possibilities of not shrinking the log file is open transactions into the log. Have you checked for any open transactions?

To overcome this problem just delay shrink job by 1...

Tom,

Yes, easy and that too have 2 points 😉

Cheers!

My suggestion is to capture load during peak hours rather than average.

You can use PERFMON to capture required details.

HTH

That's what above link says.

Hello William,

Please refer the following two links which might help you to justify to the management.

http://www.sqlservercentral.com/articles/Performance+Tuning/analyzingmemoryrequirementsforsqlserver/2498/

http://msdn.microsoft.com/en-us/library/aa175395(v=sql.80).aspx

HTH

Got incorrect.

But thank you for nice question. New learning.

SQLSKILLS Link is super and my favourite site too.

Cheer!

One more good question 🙂

Is there any bulk transactions running on the database? Commit the transactions in small chunk and increase the tlog backup frequency may help.

Try to narrow down when exactly issue happen?...

sqlapprentice (4/28/2011)

Just tested on one of our mirrored pair, yes, the secondary file if added on principal is also added on...

Does adding additional primary/secondary file too applied on mirror?

dbcc dbreindex will work but it will be removed in the future version of the sql server.

Hence advisable to use Alter index from sql server 2005 onwards as mention...

If SQL cluster is in place you can detach and attach log file on the SAN. If not need to set up the cluster and do the detach and attach...

Microsoft says "You cannot back up or restore individual tables."

Best option in my openion is restore full + tlog backup to new database and extract the table data.

Else you need...

In addition to the above dbowner is having full permission on database.

If you are have decided to go with flushed the proc cache; make sure you flushed the correct and specific cache which is problamatic (as per your investigation). And make...