Sunday, 12 April 2015

Restoring database from .mdf files of SQL SERVER 2012

Today am going to explain today how to restore mdf file into sql server 2012.

Step1: first we need to save the ,mdf and .ldf file save into the following folder

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

Step2: Open the sql server management studio ans select the database then choose attach

Click on Add button, it will open the file dialog box to select the .mdf file.

Thursday, 2 April 2015

How to Restore Azure SQL DataBase

Hello Folks,

Microsoft Azure SQL DataBase has built-in support for backup and self service point time of restore DataBases based Azure Subscriptions this can be allowed only for Basic, Standard, Premium and there is no restore option for Web and Business subscriptions.

The Backup retension period also based on the Subscription.

For Basic - 7 days, Standard - 14 days, Premium - 35 days.

Now creating the test DataBase in Azure and am deleting the DataBase.

There is an option of Restore in Bottom panel

Click on that, it will open a window for typing the DataBase name.

Type your deleted DataBase name and Click on Ok.

Now the DataBase is online.

for more information about Azure SQL DataBase Baup and Restore read this Document.

How to change Azure DataBase Size

Hi,

While working With Azure DataBase, By default creation of DataBase the Limit is coming as 250GB.
This we can change in Azure management Portal.

1. We need to select the DataBase.
2 Go to Sclae tab and there is a maxSize ComboBox it will show.

While changing Limitations follow this Document.

Wednesday, 1 April 2015

The type or namespace name 'SharedAccessBlobPolicy' could not be found (are you missing a using directive or an assembly reference?)

Hi,

While Working with Window Azure Storage, NuGet Manager provides necessary dependencys like Azure management Blobs, ShareAccessBlobPolicys.

Install nuGet Package.

And add the references of namespaces like.

using Microsoft.WindowsAzure.Storage;

using Microsoft.WindowsAzure.Storage.Auth;

using Microsoft.WindowsAzure.Storage.Blob;