backup
in [Server Configuration]
|
Prev: Not able to backup database to different folder
Next: How to get list of string for particular condt
From: rino_abraham on 17 Jun 2010 00:19 Hi......... m running this code for backing up and to have backup log backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log adventureworks to disk='g:radvent6.trn' after the backup log command executes shows the error as The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. Msg 3013, Level 16, State 1, Line 1 BACKUP LOG is terminating abnormally. what should i do how could i correct it .pls suggest.
From: Uri Dimant on 17 Jun 2010 01:26 ALTER DATABASE adventureworks SET RECOVERY FULL "rino_abraham" <u61016(a)uwe> wrote in message news:a9a4e8146318b(a)uwe... > Hi......... > > m running this code for backing up and to have backup log > > > > backup database adventureworks > to disk = 'g:radvent6.bak' > mirror to disk='g:radvent7.bak' > with format,checksum,stop_on_error > > > > > > use adventureworks > insert into HumanResources.department > (name,groupname)values('dreee','reserch') > > > backup log adventureworks > to disk='g:radvent6.trn' > > > > > after the backup log command executes shows the error as > > The statement BACKUP LOG is not allowed while the recovery model is > SIMPLE. > Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. > Msg 3013, Level 16, State 1, Line 1 > BACKUP LOG is terminating abnormally. > > > what should i do how could i correct it .pls suggest. >
From: rino_abraham via SQLMonster.com on 18 Jun 2010 08:06 Thanks for your reply it was helpful........ Uri Dimant wrote: >ALTER DATABASE adventureworks SET RECOVERY FULL > >> Hi......... >> >[quoted text clipped - 21 lines] >> >> what should i do how could i correct it .pls suggest. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201006/1
From: rino_abraham via SQLMonster.com on 18 Jun 2010 08:06
Thanks for your reply it was helpful........ Uri Dimant wrote: >ALTER DATABASE adventureworks SET RECOVERY FULL > >> Hi......... >> >[quoted text clipped - 21 lines] >> >> what should i do how could i correct it .pls suggest. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201006/1 |