Hi,I would like suggestion as to what is the best way to backup my data. Previously we had a tape drive and our backups were scheduled to be backing up there. But when the tape drive failed which somehow led to our server crashing the tapes were not pointing to the correct data at all. It was poiting to 3 months back data upon restoring. So we have now decided to do away with the tapes. We have 11 databases in sql server that we backup. ten are small and the main db is 4 gb currently. Before it grew to 4 gb the db maintenance plan was scheduled to backup on an external 40 gb hard disk and then i would zip the files and burn a cd of all the databases. I cannot do that anymore coz the main database cannot be zipped as its too big. Win zip allows max 4 gb to be zipped. Also all cannot fit on a Cd after even being zipped. I need a permanent solution as to what is the best way to do backups in my case excluding anything to do with tapes. The main database will keep on growing and also i cannot backup on an external hardisk alone. I should have another copy of it somewhere as well. Please advise me as to what i should do in my case.
desperate for an answer.