Is this a homework assignment?

Can you post the schema as it is now?

The quiz table as you describe it is in violation of 1st normal form. It has repeating groups....

Not exacly, but they're very different from restoring user databases. Books Online has a good section on restoring the various system databases.

Is the database online?

Can you try and run a backup from the query window -

BACKUP DATABASE Emp TO DISK = ' Full path to backup file here '

If...

I'll see if I can get an explanation from someone for the pull back and when it'll be available again.

It says that a deadlock occurred and this process (whatever it is) was the deadlock victim and hence it was killed.

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic615879-19-1.aspx

And model if you've made any changes to that.

We are sorry, the page you requested cannot be found.

Looks like it's been pulled back for some reason...

Why not. I've only had one twit so far this week. I don't have the answer he wants,...

Can't be done.

SQL doesn't keep track of that information unless you set...

There shouldn't be any damage

the...

Ok...... Never seen that before.

If it's stack dumping, you need to call customer support.

Do you do dev, admin and BI?

Now as I...

By unrecoverable, do you mean the deadlock detector's not picking it up? Does having traceflag 1222 on result in a deadlock graph in the error log?

Not enough information.

Can you post the message 1 line above that in the error log. The one that reads Error ... Severity .. State ...

With a login failure, the...