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
>
Showing posts with label step. Show all posts
Showing posts with label step. Show all posts
Friday, March 9, 2012
Wednesday, March 7, 2012
File System Task: Move/Rename
I can use the File System Task to Move a file from one directory to another and to rename a file, but is there a way to do this in one step, i.e., move file named 'c:\foo.txt' to 'c:\backup\foo_bkp.txt'?You should be able to accomplish this in an expr.|||
You can use a script task to do this. See here: http://blogs.conchango.com/jamiethomson/archive/2005/09/14/2149.aspx
OK, maybe I'm being dense ... but how? I have both Source and Destination set to variables. The "Move File" facility only accepts a directory as the Destination because when I coded it with a new file name, I got an error due to the destination file name being ["DestVariable"]\["SourceFileName"] so it looked like:
c:\backup\foo_bkp.txt\foo.txt
|||Raul,You can use a script task to do this. See here: http://blogs.conchango.com/jamiethomson/archive/2005/09/14/2149.aspx
-Jamie
Subscribe to:
Posts (Atom)