Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Goodway
Starting Member
3 Posts |
 Posted - 2005-11-08 : 10:33:49
|
| 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. |
|
|
chris_wood99
Yak Posting Veteran
70 Posts |
Posted - 2005-11-08 : 10:43:17
|
| You can't pick which tables you want to backup in MSSQL. Can't you schedule a backup overnight to do a full backup? 20gb should take no longer than 1 hour even with a fairly low spec server and will be compressed to a smaller .BAK file. I tend to backup the database locally and then copy it too tape.If you really don't have time to Do a full backup till the weekend then the next best option is to do a differential backup every night, this will backup all data that has changed since the last full backup. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-08 : 10:52:23
|
| You ought to also make Transaction Log backups - about every 10 minutes sounds like a good idea if data is changing frequently, and is critical. (For this your database needs to be set to a Recover Model of "Full" rather than "Simple")What doesEXEC sp_spaceusedoutput?Kristen |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-08 : 10:54:01
|
| I recommend scheduling a full backup to run once per day, and scheduling transaction log backups to run every 15 minutes. This will give you good data security for most applications. Your database should be set to full recovery mode to be able to do transaction log backups.You should also make sure you backup the system databases: master, model, and msdb.Your first source of information on backup/restore should be SQL Server Books Online. You can setup backups using the Maintenance Plan Wizard to get you started if you have never setup backups before.CODO ERGO SUM |
|
|
|
|
|
|
Back up advise