Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Backup failing Expand / Collapse
Posted Wednesday, December 5, 2012 6:04 AM



Group: General Forum Members
Last Login: Monday, November 28, 2016 3:25 AM
Points: 1,537, Visits: 2,795
Joie Andrew (12/5/2012)
Hemant.R (12/5/2012)
but if you are running maintainance plan for backup job then it is necessary that intergartion service in running state .
if it not started then your job will fail.

If that was true, then you should not be able to schedule maintenance plans for your database backup\maintenance activities if you didn't install Integration Services.

- Divine Flame

It is easy enough to verify that it is not true. Look at an instance of SQL without Integration Services installed. There should not be any Intergration Services service listed in SQL Server Configuration Manager yet you can still create and run Maintnenance Plans.

Yeah, Thats what I meant when I wrote my comment

Sujeet Singh
Post #1392952
Posted Thursday, December 6, 2012 3:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 4, 2016 12:49 AM
Points: 246, Visits: 669
Guys got it.. !

i restored database who was in restoring mode.. and than try my backup job manually and it works..!

for restoration I used below command;

Restore Database <Databasename> with Recovery;

thanks all for your help and suggestions.!


Post #1393415
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse