I'm not sure what would cause that but if you want to see if you have a corrupt DB run dbcc checkdb.

How is performance, particularly CPU usage on the server when you're getting that error? It may be the server is overloaded.

It still has to obey schema modification locks but it doesn't need to take out any other locks. As such, much of the waiting on the lock logic is...

If people believe them then it's relevant to address in an...

In fact, I’d argue that you need to design precisely for specific relational database management...

Paul Hunter (5/31/2012)

---

I hear the argument "we don't want to be locked in" from the app dev folks - the same ones that aren't afraid to be locked in to...

If you...

Interesting that "as many as you want created" is the most popular incorrect option. There's always a limit of some sort.

Or consider a DB user without a server login to be orphaned.

Try doing it with a user DB. It sounds like system DBs may behave differently.

That should be possible. However, the following article says that system DBs can only be restored to the same version.

http://msdn.microsoft.com/en-US/library/ms190749%28v=sql.100%29.aspx

It's a little unclear about SPs but from...

1) What is your RPO (recovery point objective)? You want to make sure you don't lose more data than can be tolerated.

2) What is your RTO (recovery time objective)?...

If this is to make it so that support staff don't block application usage I would recommend you start with education. Even without blocking "select * from dbo.reallybigtable" can...

The method I would use to do this would be rather different just because of how we work. I would drive creating the restore statement off the backup. ...

vikingDBA (5/17/2012)

---

One thing to note is any difference in the drives and directories that the restored live data files go to. I have several SQL Servers myself, so any...