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!

Welcome to IT Matters (a getWebEdge() blog)

If you are looking for the best source for Corporate Training in Jacksonville Florida or Orange Park Florida, you have come to the right place.

We suggest GetWebEdge Corporate Training for all of your training needs.  GetWebEdge is a Microsoft Gold Certified Parnter for Learning Solutions and holds several other core compentencies as well.  Our record with Java training is outstanding as well.  We love to train and it shows.

Check out GetWebEdge's site at http://www.getwebedge.net or click on the links below:

• Visual Studio 2008
• Visual Studio 2005
• Java

One of the best things about GetWebEdge is that we will customize the course for your company.  To make sure that you are getting the most out of your valuable time and the most for your money.

We have a Corporate Rewards program, we also have a Pre-Paid Block Rate program, and if it is your company's first time at GWE ask about a discount! 

The people at GetWebEdge are knowledgeable and super friendly.  Call us for your next training class.

 (904)264-9394

Ask for Marsha Roberts.