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 2005 Forums  SQL Server Administration (2005)  Partial backup and restore

Author  Topic  Egor77 Starting Member 1 Post Posted - 2009-03-19 : 04:48:44 1. Some of database filegroups are readonly. I take a full backup of database from first server then restore it on second server using MOVE clause to place all filegroups to other directory (not to that which was stored in backup file) 2. After that I take a READ_WRITE_FILEGROUPS backup of database from first server and restore it on the second server WITH PARTIAL, NORECOVERY and MOVE (MOVE only for rw filegroups) 3. finally I do on the second server RESTORE DATABASE WITH RECOVERY and expect that read_only filegroups will be also online but no luck. The question is why the 3 step not bring online the read_only filegroups?