Restoring Database or Files/Filegroups

Hello:
In SQL 2005 Management Studio, what is the difference between restoring
"Database" and "Files or Filegroups"? When you right-click on a database and
you choose Tasks...Restore, you have a choice between "Database" and "Files
or Filegroups". What's the difference?
Choosing "Database" seems to work better, if I am restoring a backup of one
database into another database. But, I think if I'm restoring a backup of a
database into the same database, I usually choose "Files or Filegroups".
childofthe1980sMy understanding you want to use FileGroup/File backup if you need to do
separate backups on the files in the database.
Lets say you have three file groups:
FileGroupA - Primary HEAVY USAGE
FileGroupB - Read Only
FileGroupC - System Objects
So you can create a backup plan that backups FileGroupA on regular basis and
do a FULL backup once a week so as to speed up backup processes.
But if you have only one file group in databases (most ppl do), I don't
think you notice a difference.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"childofthe1980s" wrote:
> Hello:
> In SQL 2005 Management Studio, what is the difference between restoring
> "Database" and "Files or Filegroups"? When you right-click on a database and
> you choose Tasks...Restore, you have a choice between "Database" and "Files
> or Filegroups". What's the difference?
> Choosing "Database" seems to work better, if I am restoring a backup of one
> database into another database. But, I think if I'm restoring a backup of a
> database into the same database, I usually choose "Files or Filegroups".
> childofthe1980s|||For more info:
http://msdn2.microsoft.com/en-us/library/ms186858.aspx
--
Ekrem Ã?nsoy
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:68C22630-4D03-4B26-BE14-943DC38367F5@.microsoft.com...
> Hello:
> In SQL 2005 Management Studio, what is the difference between restoring
> "Database" and "Files or Filegroups"? When you right-click on a database
> and
> you choose Tasks...Restore, you have a choice between "Database" and
> "Files
> or Filegroups". What's the difference?
> Choosing "Database" seems to work better, if I am restoring a backup of
> one
> database into another database. But, I think if I'm restoring a backup of
> a
> database into the same database, I usually choose "Files or Filegroups".
> childofthe1980s