SQL 2012

How can we rollback mistakenly UPDATE statement change in SQL Database.?

Hello all,

Beside than my regular helpful blog posts, it’s just a discussion type blog post that might be useful to all of us.

Let’s say we have a table customer and If someone tries to update a single row within it but by mistakenly update the entire row within a customer table. while update query someone forgot to put where condition and now all the rows of customer table are updated.

Is there any solution to rollback the update statement and retrieve all rows back for that customer table.?

After research ,I have found as the only option is to restore that previously backup Database . If our database runs in full recovery mode, we can:

* backup the transaction log

* restore the database from a full backup

* restore all transaction logs (in sequence) to the time right before the accident occurred.

Also, there is some cool tool called ApexSQL-Log which allows us to rollback the changes. But I haven’t tried it yet before but I have downloaded the product and going for a test. You can easily download from the link below: http://www.apexsql.com/sql_tools_log.aspx

So if anyone knows some idea regarding on this and if there is any solution lately with the release of MS-SQL 2012  then really want to here.

Regards,

Anil Maharjan

SSRS-2012 Reporting Services Configuration integrate in SharePoint 2010.

Hello all,

Once again , time for some blog post and today I just want to share some tips regarding the SSRS 2012 Reporting services configuration integrate in SharePoint 2010.

Recently, I tried to integrate the SSRS 2012 within SharePoint 2010 and configure the reporting services from native mode to SharePoint integrate mode in order to integrate reports from the SSRS server in the SharePoint site.

For this generally, we use the Reporting service configuration manager and within the configuration manager, I cannot set the  report server mode to SharePoint since it is default set to native mode and there is no any dropdown box to choose to SharePoint mode and create RS-database.

Finally , after some Research I found that :

It’s not possible anymore with SQL Server 2012 to configure Reporting Services for SharePoint in the Reporting Services Configuration Manager. We have to use the SharePoint Central Administration to Configure Report Server Integration in SharePoint mode.

Check out the link below for the solution for this thread

http://technet.microsoft.com/en-us/library/gg492276

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/358ac527-ac08-4f2c-8d6f-384c35dd9db8

http://technet.microsoft.com/en-us/library/bb326213.aspx

Thanks,

Anil Maharjan