Database will not be backed up because it does not

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Database will not be backed up because it does not

Author

Topic

vasi
Starting Member

11 Posts

Posted - 2012-06-11 : 09:56:29

Hi All,
My env is sql server 2005. we are taking transaction log backup using Maintenance plan script . i am not able to take backup .
i am getting below error
Database 'database_name' will not be backed up because it does not have its recovery model set to Full or BulkLogged.
Kindly Help me , to resolve this issue .
Thanks
vasi

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-06-11 : 10:23:42

http://lmgtfy.com/?q=sql+server+how+to+set+the+recovery+model

No, you're never too old to Yak'n'Roll if you're too young to die.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-06-11 : 10:57:11

USE [master]
GO
ALTER DATABASE [My_DB] SET RECOVERY FULL WITH NO_WAIT
GO

Then take a FULL BACKUP

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

vasi
Starting Member

11 Posts

Posted - 2012-06-12 : 04:29:25

Thnaks jackv
i hope its going to helpful.

Sachin.Nand

2937 Posts

Posted - 2012-06-12 : 07:50:18

You are trying to set up a Tlog backup which is not possible when the recovery mode is set to SIMPLE.You have to change it to FULL or Bulk Logged.

You can use the script posted by jackv to do so.

After Monday and Tuesday even the calendar says W T F ....

vasi
Starting Member

11 Posts

Posted - 2012-06-12 : 11:21:50

Hi jackv/sachin,
Thanks for the reply ,Am I need to execute above query every time while running backup script. Is it ok if i execute once ?
can I know, how to see the Tlog backup job script in Sql server 2005?

Thanks
Vasi

Sachin.Nand

2937 Posts

Posted - 2012-06-12 : 14:41:54

No you have to execute the script only once.

You can check the sql jobs which get created by the maintenance plan.

After Monday and Tuesday even the calendar says W T F ....

vasi
Starting Member

11 Posts

Posted - 2012-06-12 : 20:44:12

Hi sachin,

Thanks for the reply,From the maintenance plan (it’s already created) running the scripts, but how to see the running backup script in maintenance plan? Can I have steps plz. Not Graphical

Thanks
Vasi

Sachin.Nand

2937 Posts

Posted - 2012-06-13 : 00:42:35

Just right click the maintenance plan and click modify and then double click the maintenance step.A pop up will appear which will have the "View T-SQL" button.

After Monday and Tuesday even the calendar says W T F ....

vasi
Starting Member

11 Posts

Posted - 2012-06-13 : 22:35:07

HI ALL,
In production my cpu is high all the time.
when i query Select * from master..sysprocesses where SPID > 50 order by CPU desc
i saw the BROKAR_TASK_STOP =1188343(CPU)

can any one help me
what are the steps to do come done the cpu down ?

Thanks
Vasi

Sachin.Nand

2937 Posts

Posted - 2012-06-14 : 00:54:41

quote:
Originally posted by vasi

HI ALL,
In production my cpu is high all the time.
when i query Select * from master..sysprocesses where SPID > 50 order by CPU desc
i saw the BROKAR_TASK_STOP =1188343(CPU)

can any one help me
what are the steps to do come done the cpu down ?

Thanks
Vasi

Is that related to your original post ? Does not look that way.

Create a new thread for it.

After Monday and Tuesday even the calendar says W T F ....

vasi
Starting Member

11 Posts

Posted - 2012-06-17 : 22:57:17

HI all

Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'
\\\\rpstorage\\sqldump\\MSSQL\\BACKUP\\File',N'trn',N'DATE TIME',1
" failed with the following error:
"A severe error occurred on the current command.
The results, if any, should be discarded.
A severe error occurred on the current command.

The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,

parameters not set correctly, or connection not established correctly.

Can any one tell about the issue and which parameter i have to set for script ?

Anne1234
Starting Member

3 Posts

Posted - 2012-06-20 : 02:57:47

Hi, This is a good post, indeed a great job.. You must have done good research for the work, i appreciate your efforts.. Looking for more updates from your side.

anne Shirley

vasi
Starting Member

11 Posts

Posted - 2012-06-20 : 04:03:27

Hi anne,
Thanks for reply we are finding sol to the problem .
can you have the sol let us now.

thanks
vv

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources