complete database backup directory is invalid in sql server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » complete database backup directory is invalid...

complete database backup directory is invalid in sql server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

DBAsql-1046554

Posted Wednesday, September 16, 2009 5:53 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 10, 2010 9:50 PM
Points: 23, Visits: 104

Hi,

I had a db maint job scheduled previously and running successfully.
Now i need to change the backup location pointing to some other server (server\folder).
While modifying this in db maint paln i got an error as
"complete database backup directory is invalid in sql server 2000 "

Please provide your suggestions to resolve this?

Thanks for your help.

Post #788852

Steve Jones - Editor

Posted Thursday, October 08, 2009 5:06 PM

SSChampion

Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166, Visits: 6,925

Are you pointing to a remote drive? I'm not sure you can do that in the maint plan, or that you want to do this. If there's any network hiccup, the backup will fail.

Post #800430

George Parker-378530

Posted Thursday, October 08, 2009 5:13 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:01 PM
Points: 113, Visits: 376

Here's the link to an MS URL that explains how to do this: http://support.microsoft.com/kb/555128

But as Steve Jones indicated, I'm not sure it's a good idea to do this for the reason that he indicated. Any hiccup network connectivity and the backup jobs will fail. On production systems, I almost always insist on a separate local drive array for database backups.

Post #800434

« Prev Topic | Next Topic »

Permissions