One more easy one.

anonymous_at_discussions.microsoft.com
Date: 09/21/04 

Date: Tue, 21 Sep 2004 10:24:52 -0700

What's the use of Filegroup backup?

Let's say we have around 60 tables. 30 in one filegroup
rest are in another filegroup.

What's the application of backing up only filegroup
instead of whole databse.

Because in any situation if we have to restore WHOLE
database. We can't just restore just 30 tables (in 1
filegroup) we have to restore the WHOLE database.

How would the integrity of databse is mainained if we
restore from filegroup datbase of filegroup1 taken at 2 pm
and restore from filgroup datbaase of filegroup2 taken at
3 pm.

Relevant Pages

  • Re: VLDB backups and partial restore
    ... if you do filegroup backups of the ... which is different from doing a 'partial' restore. ... The database cannot be recovered because the files have been restored ... CREATE DATABASE mytest ...
    (microsoft.public.sqlserver.server)
  • Re: Question about restore database and create new filegroups
    ... RESTORE won't help you here, since a restore database will be an image of the source database. ... For a table which doesn't have a clustered index, you just create a clustered on the desired filegroup and then drop that clustered index. ... I want to create separated filegroups and data files to re-organize ...
    (microsoft.public.sqlserver.server)
  • Re: PARTIAL SQL Server RESTOREs
    ... DROP DATABASE mywind_part ... ALTER DATABASE mywind ADD FILEGROUP new_customers ... -- A full database backup is performed. ... RESTORE FILELISTONLY lists the database ...
    (microsoft.public.sqlserver.server)
  • Re: Large Database Recovery
    ... Test the recovery to restore everything EXCEPT the history filegroup.... ... THEN try to restore the history filegroup... ... Wayne Snyder, MCDBA, SQL Server MVP ... gigabytes of images. ...
    (microsoft.public.sqlserver.server)
  • Re: Filegroup restore problems
    ... Click Leave database operational. ... but able to restore additional ... transaction logs if another transaction log backup is to be applied ... It seems that the log file backup was not taken before the filegroup backup. ...
    (comp.databases.ms-sqlserver)