Colin, I see the logic. So, in other words if the system is on the SAN it shouldn't matter what the size is.

I don't even know how to change...

you bet i will. appreciate, that is

what kind of environment? Are you using integrated security in AD/Kerborose environment? Are you getting SPPI error?

Is the error the same with sql and NT authentication?

look at sql logs as...

makes sense, thanks

You want the log to be small in order not to stress the log reader agent, is that it?

Thanks

no.

Hi Nicholas,

Nice article, I enjoyed reading it.

BTW, what is the benifit of using the dts vs scheduling these steps from a job? I am assuming both will be done...

YES, but the logs have to be in sequential order.

1. restore the database from the full backup (.bak file)

2. restore any differential backups, if any

3. restore logs in sequential order.

if...

Rick, this is interesting. Do you mean your job backs up logs to one .bak file rather than .multiple .trn files? But how does it not overwrite it everytime, if...

off course, what a dumb***s I am!!

Thank you

it sounds like the search is on Message number, which is not indexed. Clustered index is placed on PK by default, but if your select is like:

SELECT * FROM table_nameA

WHERE...

Carl, two questions:

By "thruput capabilities of the disk" do you mean I/O capacity for the drives, like 100 I/O/sec?

Also, why do you look at individual disks, what if you...

thank you.

actually, I take it back. Just found blackbox.trc file help in BOL.

Can't let developers run create table in production, much less REBOOT THE SERVER! I would be in there with a big whip and a loudspeaker.