Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:17 AM
Points: 1,312, Visits: 2,492
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: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
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.!

Regards,

Jitendra
Post #1393415
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse