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 |
choockd
Starting Member
1 Post |
Posted - 2007-02-14 : 22:09:21
|
Hi,If i am using simple recovery mode for my database,when i backup, i only need to backup the database and leave the transactionlog alone without backup?Or I need to backup both?ThanksDavid |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-14 : 22:25:07
|
You cannot backup the transaction log if you are in simple recovery mode.CODO ERGO SUM |
|
|
|
|
|