| Author |
 Topic  |
|
|
vasi
Starting Member
Singapore
11 Posts |
 Posted - 06/11/2012 : 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
Flowing Fount of Yak Knowledge
Germany
8513 Posts |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1767 Posts |
Posted - 06/11/2012 : 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
Singapore
11 Posts |
Posted - 06/12/2012 : 04:29:25
|
Thnaks jackv
i hope its going to helpful.
|
|
|
|
Sachin.Nand
Flowing Fount of Yak Knowledge
2937 Posts |
Posted - 06/12/2012 : 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
Singapore
11 Posts |
Posted - 06/12/2012 : 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
Flowing Fount of Yak Knowledge
2937 Posts |
Posted - 06/12/2012 : 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
Singapore
11 Posts |
Posted - 06/12/2012 : 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
Flowing Fount of Yak Knowledge
2937 Posts |
Posted - 06/13/2012 : 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
Singapore
11 Posts |
Posted - 06/13/2012 : 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
Flowing Fount of Yak Knowledge
2937 Posts |
Posted - 06/14/2012 : 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
Singapore
11 Posts |
Posted - 06/17/2012 : 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
USA
3 Posts |
Posted - 06/20/2012 : 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
Singapore
11 Posts |
Posted - 06/20/2012 : 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 |
|
|
| |
Topic |
|
Database will not be backed up because it does not
