:::: MENU ::::

Posts Categorized / SSMS tips and tricks

  • Feb 02 / 2009
  • 0
dbDigger, Monitoring and Analysis, SSMS tips and tricks

How to generate Instance level reports through SQL Server Management Studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to generate Instance level reports through SQL Server Management Studio (SSMS). Follow these steps in your SSMS

Generate Server Instance Level Reports

From here you may choose required report.

  • Jan 31 / 2009
  • 0
dbDigger, SSMS tips and tricks

How to create new database through SQL Server management studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see How to create new database through SQL Server management studio (SSMS). Follow these steps in your SSMS

 

Create New Database-1

 

Create New Database-2

 

Create New Database-3

 

Create New Database-4

 

At the end click Ok to create database with given settings.

  • Jan 30 / 2009
  • 0
dbDigger, SSMS tips and tricks

Detatch SQL Server database through SQL Server management Studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to detach SQL Server database through SQL Server management Studio (SSMS). Follow these steps in your SSMS

 

 

Detach SQL Server database-1

 

Press Ok and required operation will be performed.

  • Jan 29 / 2009
  • 0
dbDigger, SSMS tips and tricks

how to connect to a service or instance within SSMS

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to connect to a service or instance within SSMS. Follow these steps in your SSMS

Connect to Service or instance

From here you can choose any service to log on into. Your current session in SSMS will be remain active as long as you disconnect it.

  • Jan 27 / 2009
  • 0
Backup and Restore, dbDigger, SSMS tips and tricks

Backup SQL Server database through SQL Server Management Studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to backup a database through SSMS. Follow these steps in your SSMS

Backup SQL Server Database-1

 

Backup SQL Server Database-2

 

Backup SQL Server Database-3

 

Backup SQL Server Database-4

 

Backup SQL Server Database-5

 

Click Ok and backup process will be started.

  • Jan 27 / 2009
  • 1
Backup and Restore, dbDigger, SSMS tips and tricks

Attaching SQL Server database through SQL Server Management Studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to attach a database through SSMS. Follow these steps in your SSMS

Attach SQL Server Database-1

 

Attach SQL Server Database-2

 

Attach SQL Server Database-3

 

Attach SQL Server Database-4

 

Then click OK to start the attach process.

Consult us to explore the Databases. Contact us