backup on maintenance plan doesn't work.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » backup on maintenance plan doesn't work.

backup on maintenance plan doesn't work.

Rate Topic

Display Mode

Topic Options

Author

Message

Jasper_visiter

Posted Monday, March 22, 2010 12:01 PM

Grasshopper

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

GilaMonster

Posted Monday, March 22, 2010 12:08 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

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

Jasper_visiter

Posted Monday, March 22, 2010 12:20 PM

Grasshopper

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

GilaMonster

Posted Monday, March 22, 2010 12:36 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

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

Jeffrey Williams 3188

Posted Monday, March 22, 2010 2:19 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317, Visits: 9,216

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 »

Permissions