Find out what is causing the error, then do a dbcc checktable, odds are an index is out of whack, rebuild indexes on that table.

dankwart menor (11/16/2007)

---

Certainly I got your point, Don Corle... äh Grasshopper. Except from this one: Whats with the "init"?

Full backup with init

Diff Backup with init

Log Backup

Log Backup

Log Backup

Log...

Lets say you have a production trading database and you backup every night, and do only one log backup midday, sat at 1:00PM. If that db crashes at 12:40PM,...

I had the same issue and SP4 resolved it, but it caused other issues such as io waits and long running transactions.

yes, especially for OLTP systems where you want to be able to recover up to a reasonable point in time.

I typically do:

Full goes to it's own BU device

Diff and Logs...

I would do the same, my biggest disappointment has been with SATA drives and databases, writes are extremely slow, even allocating db space is painful.

don_goodman (11/14/2007)

---

If you have not installed 2000 SP4, do so. Then the error willl not lockup your server or the db. If you have installed it then the error does...

I believe this simple query will work:

from db in question:

select name, (size * 8)/1024 from sysfiles

will give you size in MB

Do you backup/truncate your transaction log at all ?

For production databases I typically do it every 1/2 hr.

Sounds like you need to backup/truncate your transaction log

shrink it, and then backup/restore.

or...

If you just want to shrink the log:

select name from sysfiles (to get logfile name)

dbcc shrinkfile(logfilename, SizeInMB)

Yes, I was looking for a best practices document outlining such as in this doc for sql 2000:

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

Right click in "design package" window, then choose save, this works instead of trying to save when exiting EM2000

Has anybody heard from MS about this ? The 2000 and 2005 clients (with DTS Designer) cannot coexist on the same WS, this is a big problem for me....

Dynamic SQL has given me the ability to convert 1000s of lines of old Sybase SQL code to 100s of lines of code that are lookup file/table driven.