Our database is big (about 320 GB) and it takes some time to backup and restore. The client wants us to suggest techniques that would reduce the time. I have tried "piecemeal" restoring, which allows you to backup and restore individual filegroups in the database. It works fine with all the filegroups -- except for the FILESTREAM ones, which I can backup but not restore. Can you suggest how to do this or any other workaround that will reduce the backup and restore time.
October 26, 2009 4:39 PM
October 27, 2009 3:27 AM