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 |
|
kpsreenath
Yak Posting Veteran
52 Posts |
 Posted - 2006-02-07 : 10:01:50
|
| Hi I need to change some databases from the simple recovery model to FullI have unchecked the option of Truncate log on checkpointShould I uncheck the select into/bulk copy to get the database in the full recovery mode? I want the database in Full recovery mode and not bulk logged. My confusion is that if i uncheck it whether the bulk logged operations are logged or not logged?Thanks in advance |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-07 : 10:25:34
|
I can't remember clearly back to SQL 7, so I dunno if this suggestion will work on SQL 7, but if so you could try clicking the various checkboxes  and checking the results withSELECT DATABASEPROPERTYEX('MyDatabaseName', 'Recovery')Kristen |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-02-07 : 11:17:23
|
quote:
Originally posted by Kristen
I can't remember clearly back to SQL 7, so I dunno if this suggestion will work on SQL 7, but if so you could try clicking the various checkboxes and checking the results withSELECT DATABASEPROPERTYEX('MyDatabaseName', 'Recovery')Kristen
You should uncheck both "Truncate log on checkpoint" and "Select into/bulk copy". DATABASEPROPERTYEX was new in SQL 2000, so it probably won't be much help.CODO ERGO SUM |
|
|
|
kpsreenath
Yak Posting Veteran
52 Posts |
Posted - 2006-02-07 : 13:56:57
|
| Thanks guys, learned something new today |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-08 : 03:12:05
|
DATABASEPROPERTYEX was new in SQL 2000 Sorry about that ... |
|
|
|
|
|
|
Sql Server 7 - Recovery model Confusion