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;


Global Azure Bootcamp 2015 Hyderabad 25th April 2015

Global Azure Bootcamp 2015 Hyderabad

Microsoft User Group Hyderabad

25th April 2015

 

      Targeted audience for this event are Developers and IT pros who are already working or who are interested in learning Azure. You must provide your official (work) email id for verification purpose, otherwise your registration will not be accepted. We will not send any communication to your official email id. We will communicate over only your personal email id.
Don't register using same email id multiple times, those registrations are considered as duplicate and they will cancelled.
Students are strictly NOT allowed to this event. 


Venue
Microsoft India Development Center
Building 3, Gachibowli
Hyderabad, Telangana 500032
India




Source: http://hyderabad.azurebootcamp.net/ 

Monday, 30 March 2015

System.ComponentModel.Win32Exception from Windows Azure website

Hello,

Exception Message: Access is denied,
System.ComponentModel.Win32Exception this kind of Issue manly will come because of Azure DataBase Connection string Wrongly entered.

ConnectionString should be like this



<add name="SqlServer" connectionString=" Server=tcp:qa88bialki.database.windows.net,1433;Database=TestAzure;User ID=saapp;Password=harikrishna@!;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"/>


In the Above string qa88bialki is ServerID

TestAzure is DataBase Name,
  
 saapp is UserId for the AzureDataBase server,


harikrishna@! is the Password for that Server,