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 |
|
wgsing
Starting Member
11 Posts |
 Posted - 2009-08-22 : 22:34:35
|
| Hi All expert, How to set the database schedule daily backup? Please teach me step by step. Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
wgsing
Starting Member
11 Posts |
Posted - 2009-08-23 : 03:46:02
|
| When the Ms SQL 2005 is running the backup, will it slow down or make the system hard to update the record in Db. Because i facing the problem server traffic too heavy make some of record failed to update,. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-08-23 : 04:53:25
|
backup operation will need to access to the hard disk to read and write. It will consume some IO and will definitely has some effect on the system.But backup is inevitable. The costing of not having it is way much higher than cost of having it.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
wgsing
Starting Member
11 Posts |
Posted - 2009-08-23 : 05:37:16
|
| thanks |
|
|
|
|
|
|
Schedule Backup Ms SQL 2005