the weekly newsletter already reports when SPs come out. I don't see a need to keep up with CUs, but Steve does maintain a build list.

David, thanks but don't go there. the part of the query that performs badly only accesses one table but it is unioned to another query which accesses 19 tables. (then...

thanks for the feedback. Like any other non-read activity, shrinks are logged.

http://msdn.microsoft.com/en-us/library/ms365599(v=SQL.100).aspx

Kimberly tripp has a series of articles on log files. This is maybe related to vlf size?

start here: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

Run command select @@version

7.0.nnnn = SQL 7

8.0.nnnn = SQL2000

9.0.nnnn - SQL2005

10.0.nnnn = SQL2008

10.5.nnnn = SQL2008R2

nnnn denotes the SP\Hotfix level.

On this site do a search on 'build list'. Steve jones the...

Hemantjemmy (8/11/2009)

---

Hi,

I think I have missed two word in above comment which created confusion.

What i meant was truncate & shrink transactional log file only after taking full backup.If your database...

Looking at this from a different viewpoint there are other advantages to removing that redundant data.

all maintenance tasks will run quicker, checkdb, reindex, stats updates. Backups will also run quicker...

striping will reduce your backup times. You can do individual file or filegroup backups (see books online). If you switch to using these ensure your complete backup strategy means...

no probs. you now have a model log file with a different name to how it was installed but I don't think that will ever cause any problems. Just be...

'E:\SQLData\model.ldf' - so is that file there? are you sure its not called modellog.ldf?

Brandie Tarvin (10/15/2010)

---

That was you? Shame!

And here I thought it was the guy from the other...

SwayneBell (10/15/2010)

---

George,

I'm getting the sense that the exposure from data loss in one of these databases is inconvenient, but not fatal? (i.e. some new jobs may fail, new users could...

use notepad to view the errorlog, any errors in there?

GilaMonster (10/15/2010)

---

george sibbald (10/15/2010)

---

GilaMonster (10/14/2010)

---

Yup.

Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at...