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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2002-02-28 : 08:46:25
|
| SQL2k - I am unable to choose the transaction log for backup. The only options available are Complete and Differential. I did a complete and the transaction log option is still greyed. This is not the case in all my other DB's... I only have this problem in 1 DB. Is there some DB setting that I am missing? Maybe Bulk insert is turned on or something?DanielSQL Server DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-28 : 08:53:41
|
| Do you have truncate log on checkpoint set for that database? Or is the recovery model anything other than Full? |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-02-28 : 09:11:28
|
quote:
Do you have truncate log on checkpoint set for that database? Or is the recovery model anything other than Full?
Ah... Ok so it was set to simple. I set it to full but still no go. I need to restart the service for SQL, right? That way it will go through the recovery.Thanks for the helpDanielSQL Server DBA |
|
|
|
vicki
Posting Yak Master
117 Posts |
Posted - 2002-02-28 : 10:53:44
|
| Did you made that work?, Can you show me because I have the same problem like you hadThanks |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-28 : 11:09:08
|
| You don't need to re-start the server. After you switched to the FULL recovery mode, you have to take a full database backup, and from there on you will be able to take transactional backups. |
|
|
|
|
|
|
Transaction log backup greyed out??