FileGroup

Dear Professional
Can any body tell me give me the URL where there is any good explaination
step by step about the filegroup backup as well restoration process and all
the detail.
Thanks
Noor
Hi Noor,
Have a look into the below sections in books online:-
"Physical Database Files and Filegroups"
"Using Files and Filegroups"
"Creating Filegroups"
"Using File Backups"
"Files and Filegroups"
"Backing up and Restoring Databases"
"Partial Database Restore Operations"
"Backing up Selected Portions of a Database"
Thanks
Hari
MCDBA
"Noorali Issani" <naissani@.softhome.net> wrote in message
news:OghYmaXOEHA.1276@.TK2MSFTNGP11.phx.gbl...
> Dear Professional
> Can any body tell me give me the URL where there is any good explaination
> step by step about the filegroup backup as well restoration process and
all
> the detail.
>
> Thanks
> Noor
>
|||BOL
"Noorali Issani" <naissani@.softhome.net> wrote in message
news:OghYmaXOEHA.1276@.TK2MSFTNGP11.phx.gbl...
> Dear Professional
> Can any body tell me give me the URL where there is any good explaination
> step by step about the filegroup backup as well restoration process and
all
> the detail.
>
> Thanks
> Noor
>

filed name as a column

How can I display filed name as a column, can any body help...
There is one table name School and it contain 4 records and in the future
might be it will increase but I want to display that records as a column
like this
1........... First School
2........... Second School
3............Third School
4............Fourth School
now I want like this
First School Second School Third School
Fourth School
45 99 0
0
99 22 1
0
Thanks
Thats a crosstab thing which could be handled with y CASE statement:
http://www.paladn.com/dynamic-crosstabs.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Roy" <roy@.hotmail.com> wrote in message
news:uJ4ZN2fgFHA.1148@.TK2MSFTNGP12.phx.gbl...
> How can I display filed name as a column, can any body help...
> There is one table name School and it contain 4 records and in the future
> might be it will increase but I want to display that records as a column
> like this
> 1........... First School
> 2........... Second School
> 3............Third School
> 4............Fourth School
> now I want like this
> First School Second School Third School
> Fourth School
> 45 99 0
> 0
> 99 22 1
> 0
> Thanks
>