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 |
|
Camper66
Starting Member
13 Posts |
 Posted - 2008-08-07 : 15:18:47
|
| Hi again and thank you.....I have setup a maintenance plan that runs all the jobs with the exception of the backup of the transaction log. I am however able to run the job in Query Analyzer but still it does not seem to write the log to the directory "C:\Shipmate_logs" .EXECUTE shipmatedb.dbo.xp_sqlmaint N'-PlanID 24DA1389-8813-4E8B-A5F6-756CA516E114 -Rpt "C:\Shipmate_data\Hourly Backup6.txt" -WriteHistory -BkUpMedia DISK -BkUpLog "C:\Shipmate_logs" -BkExt "TRN"'My question is, does the step above seem correct ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-07 : 15:24:08
|
| You have excluded in maintenance so how do you expect it to write? Read Booksonline for : Recovery model. |
 |
|
|
Camper66
Starting Member
13 Posts |
Posted - 2008-08-07 : 15:42:46
|
| I originally setup the log backup in the maintenance plan, but unable to run it there so what do you mean by I have excluded it in maintenance ? I am trying to run it outside the plan... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 23:03:58
|
| You can't backup log if the db is in simple recovery model. |
|
|
|
|
|
|
Backup transaction log