|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/20/2011
Posts: 1
|
I am attempting to run this backup and not finding any reference to the error about the recovery model simple. Also, it does not change the size of the transaction log file. Thank you for any help you can give.
____________________________________________________________________________________
C:\Program Files\SQLBackupAndFTP>sqlbackupandftp.exe -r "c:\program files\sqlbac
kupandftp\new.jobx" -log
C:\Program Files\SQLBackupAndFTP>
4/20/2011 12:13:12 AM Creating backup of MIM_Core to C:\WINDOWS\TEMP (transact
ion log)
4/20/2011 12:13:12 AM ERROR: Backup of MIM_Core failed: The statement BACKUP L
OG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or cha
nge the recovery model using ALTER DATABASE.
BACKUP LOG is terminating abnormally.
4/20/2011 12:13:12 AM Cleaning D:\Bkups\SQLbkups
4/20/2011 12:13:12 AM ERROR: Job finished (With Errors)
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
In order to backup the transaction log, the recovery model for you database should be FULL, not SIMPLE. See MSDN.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
Thank you for the link! I will check it out.
|
|
|
|
|
