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 |
|
joanne
Starting Member
46 Posts |
 Posted - 2004-09-12 : 07:54:33
|
| Hi,I have to manage a SQL Server DB who is used by a web application - server A. We have also an other server for special situations (disaster, for example) - server BBoth have installed a 2003 Win OS and a 2000 SQL Server Standard Edition.Q : What kind of backup /restore strategy I need to obtain the best performance?joanne |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-12 : 11:39:09
|
| How much data can you afford to lose. How frequent are updates?Try at least a nightly full backup.maybe4 hourly diffs and hourly (or 15 min) log backups sepending on system.Make sure you test the backups.You will need implement log backups unless you set the recovery model to simple or the system will crash (and possible corrupt the database) when the tr log fills the disk.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
backup strategy