Off the top of my head, I would suspect that you are seeing the checkpoint operation in action.

See: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/98a80238-7409-4708-8a7d-5defd9957185.htm for additional information on what activities cause a checkpoint.

How often do...

snow_rose_87 (5/11/2008)

---

hi guys,i need your help. can you give me abot syntax of "select distict mid/left/right"?

i wanna select 2 characters from this record in a table to a combo box

10073010002

10072010012

10063020001

10083010001

how...

I wouldn't bother with a trigger, or some function in a trigger. This can easily be handled using an indexed view and a unique clustered index on the indexed...

How are you connecting to this other system? Are you trying to use Windows Authentication? If so, then that will use the SQL Agent account to try to...

No - you need to install litespeed on the other server. If this is a one time process, you can install litespeed in demo mode to perform the restore.

If...

Just curious - but how often are you running transaction log backups? If you are only running once a day (to shrink), then consider changing the system from full...

Try running: sp_change_users_login 'Report' in the database where you are trying to add the user. If you find any users in the list, you need to run this procedure...

Maybe by giving you an example for two SAN's I work with:

HP EVA 5000

Disk Group 1 has 104 72GB/15K drives

Disk Group 2 has 24 300GB/10K drives

When I need a LUN...

Jeff Moden (5/4/2008)

---

jeff.williams3188 (5/4/2008)

---

Jeff - can you provide a link to where it is suggested that you have a separate drive for each tempdb file? I was not aware...

It is never a good idea to shrink either the database or the transaction log on a production system. You manage the size of the transaction log by running...

Here is an idea that might work for you. Take a look at Powershell and SMO. With Powershell, you can easily create a script to loop through a...

Jeff Moden (5/4/2008)

---

peace2007 (5/3/2008)

---

Did you go buy the number of processors and create a files for each i.e if have 4 processors do you have 4 files for tempdb ..just...

Another thing to keep in mind is that on SQL Server 2005, sp_updatestats has been modified to only update statistics on tables that need it. If you use the...

Lubo Petrov (4/27/2008)

---

I just tried one more time and this is the mesage I'm receiving.The log for this backup begins at LSN 97383...33...001,which is too recent to apply to the...

To restore to a point in time, you have to restore all transaction log backups from the backup you are restoring from to the point in time you are restoring...