Pages

Men

rh

6/03/2012

Default Data bases in SQL SERVER 2005

If you want to find no of connections in SQL Server Query

Syntax: Select @@Max_Connections


For finding versions of SQL Server

Syntax: SELECT @@Version

For finding Current users Login into the Server

Syntax: SELECT Current_User



Default Databases:

  • Master
  • Model
  • MSDB
  • Temp


Master: 

  • It Contains System Configurations, Connections with out Master Database the SQL Server will not Start.


Model: 

  • It contains Models that is Templates.
  • Creating database templates
  • Creating table Template
  • Creating Stored Procedures.
  • Creating templates for restoring DB.


MS_DB:

  • It contains Data table backup
  • Dts packages
  • SSRS Variables, Folders
  • SQL Server Jobs
  • Replications


Temp:

  • It contains temporary tables information.


Backup Types:


  • Full back up
  • Transaction log backup
  • Referential back up



No comments :

Post a Comment