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 |
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
 Posted - 2007-07-08 : 19:08:34
|
| Hi,I need to clear a lot of records of a table, I don't need to keep information about it, so I switch the DB to BULK-LOGGED mode and I perform the delete operations, after it I switch the DB to FULL mode.Use MasterALTER Database myDb Set Recovery Bulk-LoggedUse myDbDELETE ....Use MasterALTER Database myDb Set Recovery FullI've read on microsoft documents that it's recommended to make a backup of the transaction log before and after switching the DB to Bulk-Logged mode.Currently I have a Maintenance Plan (Log Shipping) and I was thinking on starting the job that makes the log backupEXEC msdb.dbo.sp_start_job myJobDoes it work? or Do you have a better idea?Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-08 : 20:13:20
|
| You need start log shipping file copy and restore jobs as well. |
 |
|
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
Posted - 2007-07-08 : 20:18:38
|
| ?I don't understand you. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-09 : 11:19:45
|
| If you only start log backup job manually, may out of log sequence on target server. Since log shipping involves three jobs, log backup on source, file copy and log restore on target. |
|
|
|
|
|
|
Bulk-Logged Mode Clear data