We have a need to back up a single sqlserver database which only changes yearly. Would like to back up once, then remove from the sqlserver. It will then be rebacked up in approximately 1 year.
Been through the tdp for sqlserver manual, but I know little of sqlserver. Is this just a management class issue where verdeleted would be somewhat longer than one year, and retextra would be 0? Gary Lee Senior System Programmer Ball State University phone: 765-285-1310