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-03-21 : 06:57:39
|
| SQL Joe writes "Why do you not have the option to backup the transaction log in SQL 7.0, but you have the option in SQL 2000? Is it because SQL 7.0 automatically backups the Transaction log with the Database backup?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-21 : 07:22:57
|
| SQL Joe you are misinformed. Read the chapter in Books Online on Backup and Restore.Jay White{0} |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-24 : 13:11:06
|
| You have the option to backup the transaction log when the database is not set to SIMPLE recovery model. In 7.0, the transaction log is NOT automatically backed up with the database backup. Nor is that the case in any version of SQL Server. Where are you getting this information from?Tara |
|
|
|
|
|
|
SQL Backups