sql back up advise
-
Hi everyone, I am working in a company where data is changed daily (it is a shopping center) where item prices change everyday, quantity in stock vary daily,... What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) . could u help me with some links or idea. I was thinking of doing a full back up one time everyweek and daily I will do a differential backup? I can't do a full back up daily because data is more than 20 GB and also some tables in the SQL database hold data that is very critical and (I want to include these tables in the backup) other tables holds data not important (I don't want to include these tables in the backup). is that the best solution. Thanks.
-
Hi everyone, I am working in a company where data is changed daily (it is a shopping center) where item prices change everyday, quantity in stock vary daily,... What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) . could u help me with some links or idea. I was thinking of doing a full back up one time everyweek and daily I will do a differential backup? I can't do a full back up daily because data is more than 20 GB and also some tables in the SQL database hold data that is very critical and (I want to include these tables in the backup) other tables holds data not important (I don't want to include these tables in the backup). is that the best solution. Thanks.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx[^] That ought to at least get you started. I'm a developer, too, though, so I can't really offer any opinions on the best approach. Jon Sagara Look at him. He runs like a Welshman. Doesn't he run like a Welshman? Doesn't he? I think he runs like a Welshman. Sagara.org | Blog | My Articles
-
Hi everyone, I am working in a company where data is changed daily (it is a shopping center) where item prices change everyday, quantity in stock vary daily,... What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) . could u help me with some links or idea. I was thinking of doing a full back up one time everyweek and daily I will do a differential backup? I can't do a full back up daily because data is more than 20 GB and also some tables in the SQL database hold data that is very critical and (I want to include these tables in the backup) other tables holds data not important (I don't want to include these tables in the backup). is that the best solution. Thanks.
I'm not a DBA, but Yes, a weekly full backup with differential daily backup is a good start. Also look into log backups maybe every hour or so. In order to do partial database backups, I think the db has to be structured into filegroups; you then can choose not to backup certain filegroups. Also, some of the commercial backup software out there have suggestions for SQL backup.