do you have a log backup between steps 2 + 3?

did you shirnk the database file or the log file?

Do you have a clustered index?

SQL server agent --> Job Actvity Monitor --> Right Click --> View Job Activity

There could be a job in there that is failing due to access rights.

Could be a job that is trying to run. Check what Jobs you have enabled.

I have never seen harrasment to the level that physical violence was involved and would be very concerned if i did, I hope that most companies would have...

Mirroring will not work as the mirror has to be in-recovery meaning that it would not be accesible.

The best alternative is database replication though you still have to do...

vasko102 (3/27/2009)

---

The problem is that in my application where i plan to use this stored procedure i use one button that when you click it it has to make insert...

In the Flat File Destination Editor, Uncheck the box 'Overwrite data in the file'

Krishna (3/26/2009)

---

Are you not doing any root cause analysis and find out where the problem could be? mostly...

Have you run DBCC CHECKDB to check for corruption in the database.?

That is good news that there isno corruption, I/O errors do usually mean that then network or disk was unavailable.

You may want to do restore with verify on...

This looks like a case of parameter sniffing..

have a look at this article on how this may affect the query performance and how to fix it

http://blogs.msdn.com/khen1234/archive/2005/06/02/424228.aspx

Hard to say without a bit more information, but quite often these sort of issues relate to permissions, so check that the package is running under the...

Yes this T-SQL should be run in Query Analyser

connect to the DB server and run the code, you can specify the db name with this code

DBCC checkdb (YourDBName) WITH...