Having problems running DBCC CheckDB on your large database? 

Here are to great articles.  Check them out before opting not to run DBCC CheckDB.

CHECKDB From Every Angle Consistency Checking Options for a VLDB

dbcc checks and terabyte scale databases

God Bless and happy integrity checking!

What does SQL Server Error 3154 really mean?

Error 3154: The backup set holds a backup of a database other than the existing database.

I recently taught a class and one of my students encountered this error message.  I thought others might want to know the answer to this puzzle as well.

The error message, in this case, was really misleading.  It happened while attempting to restore the master database.  The answer is really simple:

Use the REPLACE keyword in your RESTORE statement.

Example:

RESTORE DATABASE YourDB
FROM DISK = 'C:\YourDB.bak'
WITH REPLACE

As you can see the Error message doesn't quite lead you in this direction.  But it will work. 

Good luck.  Have a blessed day!

WSPBuilder

WSPBuilder is a SharePoint Solution Package (WSP) creation tool for WSS 3.0 & MOSS 2007.  Everyone should use it!  We recommend it to all of our students at GetWebEdge Corporate Training.  Cuts your production time down and gives you more time to talk about Avatar.  (The Last Air Bender!, not the blue people)

No more manually creating the manifest.xml file.
No more manually specifying the DDF file.
No more using the makecab.exe application.

You can download it from codeplex.

http://www.codeplex.com/wspbuilder