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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-24 : 09:17:14
|
| Qing writes "I am new to ms sql server 2000. Can someone tell me how to setup a daily job to do export as part of daily backup? I already create two jobs for complet database backup and logs backup through enterprise manager. How offen do I need to backup the transaction logs? If you have any recovery procedures or daily db checkup scripts, Can I have a copy. Thanks." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-24 : 09:28:14
|
| an export of what?Your best bet is to learn about backup and recovery and write your own procedures that you understand. The frequency of log backups is soley driven by business requirements and physical storage. No one can tell you how often.Jay White{0} |
 |
|
|
|
|
|
how to setup a daily job to do export as part of daily backup