June 14, 2010 at 8:03 pm
i am a database with following structure having 3 filegroups each having 3 files ,apart from Primary filegroup.ALL filegroups are stored in different drives.Each filegroup size is 100 GB size.
out of 4 file groups one is readonly.
i want to create a backup scenerio for efficient maintance of db with the following conditions
1).when ever need i want to restore the entire db on to different Test machine?
2).When ever need i want to partialy made online?
3)when ever need i want to restor the db to a specific point of time?
4).when required i need to change the recovery model for bulk operations?
create a backup stratagey for the above all condations?
plz can any one help me to create the backup stratagy?
thankyou.
June 14, 2010 at 11:40 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic937059-357-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply