And if you want advice for performance, as you well know by now, we need the table definitions, the index definitions and, if on 2005 or higher, the execution plan...

Of the current DB, or of one of the backed up...

Depends on the disaster. If the log drive is accessible and SQL is running, you can.

HOW...

Did you restore over the existing database, or alongside?

Did you make copies of the old mdf and ldf before the restore?

To demonstrate:

Create table #Errors (id int primary key)

set nocount on

go

-- testing pk violation

insert into #Errors values(1)

insert into #Errors values(1)

print 'pk error thrown'

go

-- testing conversion

insert into #Errors values ('abc')

print 'conversion error...

RBarryYoung (12/16/2008)

---

IIRC, if the severity is 16 or greater, and there is no error-handling, then the session is terminated and any outstanding transactions are rolled back.

If the severity is 15...

Depends on the error. There are three kinds of errors in SQL. Statement...

Then you're going to have to...

Here's another one that needs some help in asking questions. Not a twit, I just don't think he knows what he's after.

http://www.sqlservercentral.com/Forums/Topic620018-360-1.aspx

I'm still not getting what you want.

All I...

I'm not quite sure what you're asking.

Grant Fritchey (12/16/2008)

---

I actually said to one parent after giving their baton twirling, uh, I mean bo handling, son a low score, "You do know that this is meant to...

Also note that the kb article mentioned (and the public url is http://support.microsoft.com/kb/960828/ as not everyone has access to the premier site) is not available at this point.

Asked and partially answered here - http://www.sqlservercentral.com/Forums/FindPost620292.aspx

That's restore, not recovery. You can, using tran lock backups, restore a database to a point...