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 |
|
landau66
Yak Posting Veteran
61 Posts |
 Posted - 2008-08-10 : 14:12:04
|
| Hello everyone!I want to save a database. when i go into the appropriate window (right mousclick to: database name - tasks - save) i just get offerd two saving types: full and differential. Where is the third saving type?? in english it should be named transaction protocoll.thank u very much in advance and greetings from viennalandau |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-10 : 14:17:04
|
| What is the recovery model used? i think its simple recovery model.You wont have option to backup transaction log in simple recovery model. change it to full or bulk logged if you want to backup transaction log. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-10 : 14:18:01
|
| Where did you see that? Take a Full backup of database. Transaction log backup appears when your recovery model of your database is Full or Bulk-Logged |
|
|
|
|
|
|
Want to save db - transactionprotocoll not availab