Fortunately I got 2 points.

The second count gives 1 but as there was no 1 in the answer hence selected 2 and got it correct.

In QOD we have...

I guess it will be difficult to find out howmany attempts are left?

You can also execute following command:

SELECT @@MAX_CONNECTIONS

The query you have executed is correct and contain maximum information about the backup and restore.

Now you would like to compare the same detail with Prod-db; the way you...

Also check the stored procedure is written efficiently...

Check following link:

http://technet.microsoft.com/en-us/library/ms187540.aspx

Generally it depends on the server and how much processes & activities are running on it.

Check if backup verification option is on? Internally when backup is done than backup plan...

Post exact command you are executing and what exact error you are getting so that people can help you.

"The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can...

It's security issue.

Following link might help you.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/8a71f08f-97d6-4c25-910d-1a8bfb78a4f5/

HTH

Use perfmon and explore "Memory" & "SQL SERVER:Memory Manager" counters.

For what reason are you looing for this option? performance?

Pl. refer following link.

http://msdn.microsoft.com/en-us/library/ms187540(v=sql.90).aspx

HTH

You can also add one more begin tran - commit tran - rollback tran after

SELECT * INTO table2 FROM table3

Before restarting the server How about running DBCC CHECKDB to check database consistancy and any errors?

If able to get sufficient time to perform it as a safer side.

HTH