Wednesday, August 29, 2007

Msg 3154, Level 16, State 4, Server YourDatabaseName, Line 1

This error tells you that the database being restored is already existing in the server. Use WITH REPLACE or Change the database Name which you are restoring.

RESTORE DATABASE YOURDATABASENAME FROM DISK='D:\YOURDB.BAK' WITH REPLACE

Wednesday, August 22, 2007

FAQ : SQL Server Certifications

The New Generation of Microsoft Certifications http://www.microsoft.com/learning/mcp/newgen/default.asp

Microsoft Next Generation of Certifications: Frequently Asked Questions http://www.microsoft.com/learning/mcp/newgen/faq/

Microsoft Certifications for IT Professionals

http://www.microsoft.com/learning/mcp/mcitp

MCITP Database Developer

  1. SQL Server MCTS (70-431)
  2. 70-441 (Designing DB Solution)
  3. 70-442 (Designing and Optimizing Data Access

MCITP DB Administrator

  1. 70-431 (MCTS)
  2. 70-443 Designing a DB Server Infrastructure
  3. 70-444 Optimizing and Maintaining a Database Administration Solution

Or If you are upgrading from MCDBA

  1. 70-431(MCTS )
  2. 70447 ( Database Administration by Using Microsoft SQL Server 2005 )


MCITP: Business Intelligence Developer

  1. MCTS: SQL Server 2005 (70-431) +
  2. 70-445: PRO: Designing Business Intelligence Solutions by Using Microsoft SQL Server 2005 Analysis Services +
  3. 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005




Friday, August 10, 2007

SQL Server 2005 Service Pack and hot fixes

single window for all Service packs and other hot fixes of SQL Server 2005.

http://support.microsoft.com/kb/913089/
 
Locations of visitors to this page