Note to self: Once my university stuff's out of the way, write a followup to my "Help my database is corrupt" article, covering the causes and fixes for suspect and...

Possibility 1: Some one deleted/misplaced a data/log file when SQL Server was offline and the database can not start because of missing file. The solution is to place the missing...

Alvin Ramard (2/8/2010)

---

I don't know if what to think about today's top headline: "A guide to recover a database out from Suspect mode". Not even one mention of DBCC...

Why?

I don't know what LiveState Recovery is, but if it's a file mirroring app, those generally don't play nice with SQL Server and often the mirrored copies aren't usable.

If...

What kind of backup and disk imaging?

There's no one single way to coy the DB. I'd say anything that gets the data into a new DB is perfectly acceptable.

Have you had a chance to look at...

The system DB ids are fixed (at least in the current versions of SQL)

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/Topic861431-17-1.aspx

Steve Jones - Editor (2/7/2010)

---

It's not in NA either. Our current lead isn't a SQL person, and also has some development area MVPs. I've had, I believe 4 leads, only...

Steve Jones - Editor (2/7/2010)

---

What's very interesting is that a few of my MVP admins from MS haven't been SQL people. So they don't necessarily judge my technical expertise, at...

It's in the other editions too, though no word of what limitations there'll be...

2008 R2 is predominantly a set of BI focused addons for SQL Server. There are virtually no changes to the database engine (I've counted 3, maybe 4). It's mostly scale...

There's no scale-out options for a single SQL Server database. If you have a datawarehouse (star/snowflake schema) check out "SQL Server 2008 R2 Parallel datawarehouse edition" formerly known as Project...

So you've actually got no unique column or set of columns that...