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 - 2005-04-12 : 08:29:14
|
| hajar writes "Hi , I created a database maintenance plan in sql200 , in Backup the transaction log as part of the maintenance planI didn't select Specify Transaction Log Backup Plan , because I don't want to create a log file to save my diskspace ,daily I run the backup unfortunatly the it's failed becuase no diskspace ..my question , did the log file created although I didn't selected ? and how can I recover that .. thanks and regards" |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-12 : 11:30:17
|
| Hajar,A lot of your questions can be answered by reading about recovery in Books Online. Look up transaction log and backup/recovery.The log file option is specified in the database properties, not in the maintenance plan. You need to look at the properties of the database to determine 1)What is the name & path of the log file, 2)What recovery level is the database set to (Full, Bulk, Simple).I highly recommend getting a backup before making any changes. Has your last disk backup been committed to tape? If not, can you copy it to another location or commit it to tape to make room? |
 |
|
|
|
|
|
database maintenance plan in sql200