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 - 2002-05-14 : 10:46:21
|
| Yan writes "How I'm able setting up transaction log dumps for SQL server version 2000 for every 4 hours from 12am until 11:59pm?" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-14 : 12:06:23
|
| The easiest way is to set up a maintenance plan. Go to MANAGEMENT | DATABASE MAINTENANCE PLANS in your Enterprise Manager and create a new one. Follow the prompts. It allows you to select Which databases are included in the current plan, and allows independent schedules for database AND transaction log back ups.Do remember that if you are on SQL 2000, your recovery model must be set to FULL under the DATABASE PROPERTIES | OPTIONS tab of Enterprise Manager. (For 7.0 you had to make sure TRUNCATE ON CHECKPOINT was not enabled).Edited by - kevin snow on 05/14/2002 12:13:23 |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-14 : 12:28:13
|
| I very much protest the use of wizards for production grade systems . . .'Dump' can have several meanings and I am not sure which you mean. Regardless look up BACKUP in Books on Line and create a scheduled job to execute the appropriate commands.<O> |
|
|
|
|
|
|
setting up transaction log dumps for SQL server 2000