OK, this looks like MOSS (Sharepoint). That can do its own backups vis sharepoint administration tool. Ask whoever runs that to increase the frequency of tlog backups and include weekends....

If log is only 1% used suggests it is being backed up. check the properties of the database, does it have a value for last log backup?

Also does this query...

shanila_minnu (10/11/2010)

---

dbcc sqlperf(logspace)...

Same amount of work to do so should be the same. Possibly less to do if kill used as only that one process has to be recovered, not anything else...

do you have 20Gb of space to do a T-log backup because it is likely to be that size.

what is the result of running dbcc sqlperf(logspace)

no ones mentioned the blocking factors to use yet - 8K for logs, 64K for data files, 4K for system databases.

You don't say which OS you are using, if less...

******* BUMP ********

Jeffrey Williams-493691 (10/9/2010)

---

Apparently, you can use this on a full backup also. This can be used when migrating a database to a new server.

Perform the full backup with norecovery...

One thing I remember about SQL 7 was that DBCC Checkdb was much more intrusive than on SQL2000 and up.

answer above is the best way to do it but log restores are also recorded in the errorlog

I would just answer yes to this prompt.

Also I would post that question on a windows forum, its not MSSQL server related.

🙂

If you are buying licenses now they will charge you R2 prices even if you...

In terms of the support you would get from MS Steve makes good points and covers it well. You would get extended support till 2016 and that means if you...

If you want to update the scheduled time via tsql use sp_update_jobschedule

Robert, thanks, we have ticks in most of those boxes some I am not sure as I have not seen the code.

As for the lock pages in memory I use...