Pages zeroed out by...

What's the latest backup you have?

Because something (bad IO subsystem usually) has done a lot of damage to that file, it's not repairable.

I am not asking for the errors you get when querying. I need to see messages relating to this database from the error log. They are not the same thing....

*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

In addition to getting those errors (which I really need to see), please run the following (exactly that command...

You've got corruption in your DB. Either the DB was corrupt before you tried moving it and you didn't notice, or it was damaged in the move.

What are the errors...

Do you have a backup?

What are the error messages in the error log relating to this DB?

EamonSQL (4/14/2016)

---

Is it possible to find out which updates were made against a first, second, third etc nested transactions?

For example, if select @@trancount returns 4 can I find out what...

You'd need to shut down the SQL instance in order to copy the files. SQL keeps the files open while it's running, no matter what activity there is on the...

They'd run under 'sa'

Disabling the account means no one can log in as it. The system processes don't need to log in.

And when the connection which created them closes and no...

Timeout is a client setting, not a server setting. It's nothing to do with cluster settings.

Timeout is the client saying it's waited too long for a database query to execute...

🙁 :crying:

Rechana Rajan (4/13/2016)

---

tmmutsetse (4/13/2016)

---

Hie i am new on this forum,please advise i do my back ups via a sql server agent job which ecxecutes a stored procedure

EXECUTE...

And if you do the restore in T-SQL?