.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to Recover accedently Deleted data without restoreing the backup ??

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
Hi I want to restore data which has been deleted accedently by user without restoring backup of T-Log.  

View Complete Post

More Related Resource Links

Restoring DATA only from a backup set

Hi, We have a backup and are trying to restore this. The original database is no longer available. When we try to restore this, we get this error: System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 84120371200 additional free bytes, while only 51382657024 bytes are available. (Microsoft.SqlServer.Express.Smo) Gave RESTORE   FILELISTONLY FROM DISK and checked the contents. The problem is with the Trans log. It is too huge and guess it was allowed to grow without any restrictions. Is there any way we can restore the backup without restoring the log? Please advice. Thanks in advance.

Filter out logically deleted data from dbf file using SSIS?

Hi Guys, while loading dbf file to sql server using SSIS,How can i filter out the records that are logically deleted in dbf file?    ~Technology Analyst~

Recover data on a Previous Page after navigating from the page and navigating back

How can i recover the data on Page1 after navigating to Page2, so that when i navigate to Page1 from Page 2 i want the unsaved data as is.

Trying to recover data from Sharepoint Workspace files

I am running sharepoint workspace as part of our Office 2010 product.  We are heavy users.  I am recovering from a hard drive crash and reinstalling all programs on a new hard drive.  I can access the old drive, and I am trying to figure out how, and where, the data might be. 

who deleted data from tables



             How to find who deleted records from table


Deleted 60GB of data from both recycle bins, database still massive. - How can I shrink it?



I have a 90GB ContentDB, that was full of 1000's of infopath forms... I have deleted all the forms, and the database remains the same size, and when I go to shrink the database it says no free space is available in SQL Server Management Studio.

Do I have to wait for the recycle bin retention date to kick in, regardless of having deleted the data from BOTH the end user and site collection recycle bins?

I really need to get the size of the database down before backing it up and moving the site collection.

Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

Setup a login account for system backup, but now allow accessing data


Dear All,

     My problem seem quite contradiction. Not sure it's possible to do. My question is we used a symmatic software to backup our SQL databases. It require an admin right SQL user account to perform it. However some of database is quite sensitive e.g HR data. I don't want to let the IT staff to make use of this privilege to read the data. Is there any solution on this?

Best Rdgs


database backup without data


is there a way to back up a database without backing up the data (table, view, procs)

also back up the jobs on a server/linked servers.


is the only option to script them all? I dont need the data just the items like I mentioned about

Tables data Backup


Hi All,

I have a requirement where i want to take SQL tables data (18 in number) and to take backup of data for every 3 months, there are millions of records are there and i want that 3 months old data should be archived and delete/truncate the data.

And how should i restore back this backup in case data is needed..

Thanks in advance...  Please advise me i am not a DBA.

Thanks & Regards,


Data deleted - how to tell when? (using .bak and .trn)

Hi there,

We had an issue overnight when some of our data was deleted. Specific rows from specific tables.

We have backup files (.bak) from before and after, and Transaction Log Files (.trn)

How can I use these to tell when the data was deleted, and by who?

Recover mdf files which got deleted after uninstalling with revo uninstaller


I had both sql server 2005 dev edition and sql server 2008 express installed on my laptop. Now there was a problem with my sql server 2008 and I wanted to reinstall it.

I made the mistake of using a third part uninstaller called revo uninstaller. This program not only executed the uninstall program of Sql Server 2008 but also deleted all related folders and registry entries. This caused the unintended side-effect of deleting even my sql server 2005 folders.

All my mdfs are gone. I tried a undelete program Recuva, but it doesnt find any mdf files.

Please help.

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend