Saturday, 28 September 2013

Reset MS SQL Server Password in Microsoft SQL Server Application

If you wish to change your MS SQL Server password then perform the bellow mentiond procedure:-

Open the Microsoft SQL Server Management Studio

  1. Connect with the database
  2. Click the Object Explorer
  3. Expand the Security folder, After that
  4. Expand the Login folder
  5. There you will find “sa account”, right click on it and go to the properties.

A new window will open up just perform the SQL Server Password Reset here.

Note*  Though you may not need to restart the MS SQL Server after the password change but if you feel you can restart the server and check if the password you set is allowing you to access the database.

If someone lost access to their database because of failed authentication due to incorrect password they can take the help of a SQL Server Password Reset tool to get back access to the database.

Friday, 27 September 2013

SQL Recovery Model- Microsoft SQL Database Recovery Architecture

There are three recovery models proposed by the Microsoft for recovery of the MS SQL Server database. Depending upon the nature of the database and budget allotment for securing it, the company may choose to apply any of these models for securing the concerned database and to.

1) Simple Recovery Model
2) Full Recovery Model
3) Bulk-logged Recovery Model

We will understand them in detail but before that one need to assert the situation by answering some critical question, they are:-

1) How much the concerned database is critical for the organization and
2) To what extent they are ready to go to secure it.

One’s you conclude that you can now easily proceed to the next logical step i.e. which recovery model is to be followed.  Here I am elaborating each of them with their definition, pros and their cons.

Simple Recovery Model :- As the name implies, the application will make a full backup of the existing database and the user will be able to retrieve and recover from the database crash by simply deploying the database.

Pros - Simplest of all and easy to manage.
Cons- Greater exposure of data from getting lost since all unsaved content will not be available for retrieval.
Syntax for applying SRM:- 
 public void
        Server srv

Full Recovery Model:- in this model  there is a lesser exposure of the data from getting lost since the backup not only contain the files of the database but also contains transitional backup files which act as intermediate and hence you are able to retrieve more database as compared to Simple database Recovery Model.

More security for the database.
Less exposure of the data from getting lost during database crash.
Highly voluminous.
Takes more time for restoration.

BACKUP DATABASE AdventureWorks2008R2
    TO DISK = 'Z:\SQLServerBackups\AdventureWorks2008R2SimpleRM.bak'

Bulk-logged Recovery Model: - It is quite similar to the full Recovery model the difference being that the backup process in it is much faster as compared to the full recovery.

Faster process with respect to Full Recovery.
Easier to deploy.
Increase risk of data loss.

The user can make a choice by taking into consideration what is the requirement and how much extra mile he is willing to go to protect its database. And when sometime tragedy struck the user and the  backup database files got corrupted the user can take the help of professional software which are able to Repair SQL Server Backup files and will give your database back in normal working condition.

Check out this blog if you wish to know further how to Take Backup in MS SQL server. The blog nicely explains how to take backup in MS SQL Server Application.

Tuesday, 24 September 2013

Repair SQL Database- Know How to Restore SQL MDF Database

It is known to every DBA that how crucial is to maintain the database. The database holds immense value to any organization and keeping them safe is paramount importance. One should keep the following points in mind to minimize data loss.

  • Create a backup in regular interval.
  • Update the drivers.
  • Keep a Hawk eye towards the Error Log File.
  • Simulate the crashing environment to understand the weak areas.
Those measures though are not full proof but help to minimize and tackle the situation in a much better way and in case if the situation leads to data corruption, it is better to repair SQL database with the help of dedicated software so that SQL data recovery can be done in an efficient way. If you wish to know how to restore the database with the help of a software you can watch this video.

Friday, 20 September 2013

Error 1105 SQL Server- Know how to remove Database Error 1105 via Microsoft

The possible reason for error 1105 is that you have either run out of the memory or you have set a limit either for the log file or the database . For full description you can check out the Microsoft page which illustrated this error 1105 in detail. The Link to Microsoft page is.