.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

Restoring Data for a specific filegroup

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server


I am trying to figure out what the best way is to seperate data physically for example different companies. One simple way ofcourse is using different database for each company. Downside is maintenance.

Another solution is different filegroups for each company by creating a partition function with ranges and assigning the companyid column from different tables to the partition scheme. This way i've only one database to maintain. The problem with this solution which i ran into is creating backups and restoring. Each filegroup can be accessed seperatly within the backup when using the partial key statement which is great. But lets say all companies want to return to their data from this morning except company 3. If i take the backup from this morning and then restore the current log backup (made no logs in between) for filegroup company3 then all other companies(filegroups) have their current data also. I wonder if there is an solution for this, am i doing something wrong or is it just not possible what i want?.

with regards

Restore sequence i use:

FILEGROUP = 'Primary'
FROM DISK='C:\Databases\Data2\BackupFromThisMorning\MultipleCompaniesDB.bak'


View Complete Post

More Related Resource Links

Hide data for specific column from a user

Greetings, I have a problem. I would like to restrict showing specific users (or roles or schemas) data in a column. First I thought DENY option will do it but figured out that it won't. DENY denies the column being in the SELECT query. I would still like to call the column but if access to the data in that column is restricted it would show only null values and not the real ones. So... I would like call the next query from user TestUser: SELECT ID,Name,Address FROM Employee But if access to Address is restricted for TestUser I would get results like: ID Name Address 1 John Smith NULL 2 Rick Ross NULL ... Is it possible to do something like that in SQL Server 2005/2008? I was thinking of storing that kind of information in a table (for which tables, which columns for which users access is restricted) and then manipulate it on the application site but my programmers tell me that they use components which always call the full table (like SELECT *).  Thank you for your answer.

Backing Up & Restoring Data.

Hello, I'n new to the SQL Server Management Studio 2008, What i have done so far: I have opened my file Datebase Selected a subfolder inside the Database called "World00" I have backed up my World00 into my Hard Drive file called World00.bak But when i open my SQL Server Management Studio 2008, my World00 is "(Restoring) i seen some videos something about a Log that i also need to restore but where can i find that log? how do i make my file come back so i can go in it and use it? and also: http://img827.imageshack.us/img827/7172/problem2.jpg Can somebody please explain to me what do these options mean? Restore Options like (WITH REPLACE), (WITH KEEP_REPLICATION), Prompt and (WITH RESTRICTED_USER) Recovery State (RESTORE WITH RECOVERY), (RESTORE WITH NORECOVERY), (RESTORE WITH STANDBY) When i clicked on my World00 I selected (WITH REPLACE), and now i think i messed it up..is there a way to recover myfile back? so i can use it? because its still on "Restoring" please help! Also i did it all the way through like Manualy i didn't put any codes SQL's Query thing because i dont know how to use them if your going to give me a Query please tell me what to do, sorry i'm new to this coding ;o All i would like to know is how to backup ~ well i know this just right click on file select full backup and job done, but restoring is kinda confusing me because i

Is there a way for me put sys.transmission_queue on a specific filegroup?

Is there a way for me put sys.transmission_queue on a specific filegroup for a database?Tom

populate specific data from table

I am trying to build an application.I have table in my database named tbl_customer.I am able to display all the customers information using MVC i.e Name,Designation, Address, PhoneNumber, Sex etc.Now I Want To Display Customer only Having Sex "Female" (Sort Out Data From tbl_customer)How I Can Do This???I Am New To Asp.net.. I Am Using VS 2010, SQL Server 2005Help In This Context, Appreciated In Advance..Regards

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.

How to Disable Specific Column in Data Grid View and write something in Cell and load data in anothe


Hello All  ,

i have data grid view and i want to disable specific column from writing in it and in another column 

i want to write something like item code and load the item name automatically in the corresponding cell in the disabled column 

i hope that i write my problem correctly and you can understand what i want :)

thanks in advance ,

Kareem Naguib

how to show specific data label or legend in the line chart


I have a line chart with date (X axis) for average numbers. I wanted to show only one number for the month at the chart or legend area. But i can show or hide whole data labels. Is it possible to have an expression box in chart area?

Thanks in advance,


DataFormwebpart to display specific folder data of a List.



I am having one requirement where the DataFormwebpart should display specific folder data of a List. For an exxample I have one list which has three folders Level 1 , Level2 and Level3 . I want that when webpart is added on SharePoint page it should display data of Level1 and not the root level data of list. 

Basically the webpart needs to be drilled to Level1 folder by default rather than root folder of List.


to insert a row of data in excel of specific font color through C#


i m using Oledb connection  to connect with excel.i wanted to insert a row of data in excel of specific color say - red..

how can i do programmatically in c#?

Unable to access Site page having data from web part after restoring it to another server



I am trying to restore site backup to another server using following powershell cmdlet:

  • import-spweb -identity siteurl -path abc.cmp

Before starting restore I have created the site with template same as present on source server. After executing the command it did not displayed any error in the Management shell window. When I checked the log file it displayed 127 warnings and 1 error as follows:

  • Error: List Images could not be imported because it uses the DocumentLibrary base template and the destination uses the 851 base template.
  • Warning: User or group 18080 cannot be resolved.

When I am trying to access the page of the page library it is navigating to error page. This page contains Data form web part which is referencing the lists in the site. In the ULS logs I found following error:

  • PermissionMask check failed. asking for 0x00000005, have 0x400000300C231061

I tried follwoing resolution steps:

  • Provided the Full permission to the current user through which am accessing the site.

Still I am not able to fix the issues. Can anybody please guide me what would be the cause of these errors and what could be the resolution.


Caml Query to fetch the data from Sharepoint List for a specific date.



I have a sharepoint list with one of hte columns being Created Date of Type DateTime and value allowed is OnlyDate.

The submitted date in my column is 05/18/2011. When I perform a search using the below CAML query, it does not give any results though I have two items with this date.

<Where><Eq><FieldRef Name='Date_x0020_Created' /><Value Type='DateTime'>5/18/2011</Value></Eq></Where>

I dont understand what is wrong with this query. Someone please help

Janaki Thakur

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