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 |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2005-08-22 : 18:56:24
|
| Hi, I was just wondering, if I have a DB for log shipping, and change the recovery model to bulk-insert before I do a dbreindex, does the log still grow as big as the full recovery model? as in when the DB in bulk-insert model, will dbreindex still writes to the log? What i'm trying to do is try to make the log files smaller for log ship when i'm doing the db reindexing job.Thanks. |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-08-22 : 19:02:25
|
| by the way, I did a test on my test server, in full recovery model, the log files does grows pretty large, but when the bulk-insert is used, the log files doesn't really grow, but both backup log files creates a pretty much same size file, which doesn't really get what I wanted. |
 |
|
|
|
|
|
DBCC to Trans log