What have you come up with so far?

Would you please clarify what you mean by strictly by command? I think I know, but I would like to be sure before going further.

Also, know the DDL (including...

Our network people support our SAN, and when we have experienced high IO we haven't seen much activity to our SAN, the channels are not very busy. Our latest...

I would turn off the auto shrink. It is possible it is causing some of your issues, as it may be shrinking a database at an inopportune time, like...

Steve,

Can you provide me with more info about your PeopleSoft environment you are having issues with? We are experiencing intermittent performance issues with our PeopleSoft Finance system at the...

It would help if you posted the DDL for the table so we could see what you are working with along with what you have actually done so far as...

I am making the assumption you are running the 32-bit version of SQL Server 2005. With AWE enabled, you may need to remove the 3GB switch and possible need...

The maintenance plan should have created a log file that should provide you more information regarding the error. The error message itself does not provide enough information.

As for controlling...

It will only autoshrink if you have autoshrink turned on (not recommended). You shouldn't shrink the physical size of your transaction log after your log backups as your transaction...

Just to be sure, were you looking at the size of the .ldf file on disk after the BACKUP LOG or were you looking at the space in the .ldf...

Awesome. If you have any advice for a wanna be author let me know by PM and I'll pass on my daughter's email address to you. She really...

Full and Differential backups do not truncate the transaction log. This is only done by a transaction log backupup (BACKUP LOG ...).

You can try this:

exec sp_MSforeachtable 'select ''?'' as TableName, count(*) as RecordCount from ?'

I'm sure others will come up with other solutions as well. 😉

Or is it -5?

😀

What would help would be to see some sample data, just as it is in the original file, just reduce the number of rows to something manageable.