choudhury.pradeep (12/23/2014)

---

Understand Restoring is not same to recovery. The full story is, in the morning I restarted the DB server, after restart when I open SSMS I check the DB...

Change the behavior of the query processor

Restore to a 2012 server, or script and recreate...

You cannot restore down-version.

A database attached to a SQL 2012 server is a SQL Server 2012 database and cannot be restored to a SQL 2008 R2 server.

The servers are the UK, not Toronto, it's not a wordpress site either. They don't have regularly scheduled maintenance daily. Something probably broke today.

If the backup is to tape, there has to be a tape drive in the server, the backup will be very, very slow and the physical device is something like...

What in the physical name leads to that assumption?

Is there anyway to find ourselves how the DB...

First things first.

Why?

There is nothing unusual about SQL using most of the memory on the server, that's how it's designed to work. You need to ensure that you have set max server...

Wrong target. I need the help after...

If you shut down Spotlight, does the deadlock go away? If so, time to call customer support.

Someone, please, help! http://www.sqlservercentral.com/Forums/Topic1645843-1549-1.aspx

As I said, you can drop the subscriber and re-snapshot. That'll do what you want....

or manually calling...

A trivial google search (bug SQL Server 2005 CheckDB maintenance plan) turns up http://www.sqlskills.com/blogs/paul/sql-2005-sp2-maintenance-plan-bug-masking-corruption/

choudhury.pradeep (12/22/2014)

---

The situation is not often on restart and occur rarely. Please clarify me, if the DB is in state of Restoring, can I recover the DB using command "restore...

John Mitchell-245523 (12/22/2014)

---

Yes, I did consider that, but then I noted that could equally be the case if a value of 1 and value of 1,000,000 were passed in for...