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