Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 filegroups backup

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-14 : 13:51:50
Bea writes "I have a VLDB with many filegroups, I don't backup this database (data warehouse), I don't backup transaction logs - the database is read only. Although, once for a while I would like to make a changes to the data on specific filegroup and then be able to backup this filegroup and restore it to our standby server. Is this possible?
Can you backup files or filegroups (SQL2000) without performing a full database backup?
I heard that for the time when I will backup filegroup I have to change the database option from simple to full, is there anything else ?
Thank you,
Bea."
   

- Advertisement -