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

backup on maintenance plan doesn't work. Expand / Collapse
Author
Message
Posted Monday, March 22, 2010 12:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 19, 2011 8:22 AM
Points: 11, Visits: 80
hello everyone,

I am doing a full backup of a database.
When i manural backup it , it works.
But when I setup a maintenance plan task to do it,it doesn't work.

this is a new installation of SQL Server.

Thanks!
Post #887559
Posted Monday, March 22, 2010 12:08 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 42,774, Visits: 35,871
Could you be a bit more specific as to the backup via the maintenance plan? If there's an error, what error, etc...


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #887569
Posted Monday, March 22, 2010 12:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 19, 2011 8:22 AM
Points: 11, Visits: 80
I ask the person who installed this server.
it was not one time installation.
their steps on the installation is:
(1) install engine, not include management studio and agent service.
(2) install SP 2 .
(3) reinstall engine and management studio and agent service without uninstall previous components.
(4) install sp2 again.


I slao made a test of the maintenance plan.
I write a simple T-SQL script on management studio, it runs good,
then I create a maintenance plan task to run only this T-SQL script,
result is the same with the full back up task,doesn't work.

So I think the problem is conflict of the original installation.

Any Idea?

Thanks!
Post #887589
Posted Monday, March 22, 2010 12:36 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 42,774, Visits: 35,871
Can you expand on 'doesn't work'?
Is there an error? If so, what error?
Does the maint plan never run?
Does it run successfully but the backup file is damaged?
etc?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #887608
Posted Monday, March 22, 2010 2:19 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:37 PM
Points: 4,389, Visits: 9,522
Are you trying to backup across the network? Is SQL Server running under a domain user account that has the necessary rights to the folder being backed up to?

Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #887677
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse