Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 17th, 2008, 05:43 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default Problem Backing Up to Share

Hi,

Thank you for your reply.

I'm trying to set up log shipping on two 2003 servers. I created the shared backup directory on the secondary server but I can't get the backups to back up there. I'm getting the error:

Cannot open backup device '\\firebucad\dfm_shipped_logs\dfm.trn'. Operating system error 53(The network path was not found.).

I can browse to the share no problem.

I changed SQL server and SQL agent on both boxes to run on the domain administrator account. I opened the share permissions to everyone and the security to everyone. I've read tons of articles about creating these share but I'm missing something somewhere and I don't know what it is.

I didn't think I had to create a backup device since I need to keep backing up different logs to that location.

Any help on this issue would be greatly appreciated.

Thank you,
Richard

 
Old July 18th, 2008, 04:20 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

I did get this working... I think. I forgot to setup the monitoring when I started the log shipping.

I can save the logs on the primary server so I'm not getting the same error but things just don't seem right still. I can't tell if the secondary is getting the files and restoring them???

Thank you for any help on these issues.

Regards,
Richard






Similar Threads
Thread Thread Starter Forum Replies Last Post
backing up through USB Shira VB Databases Basics 1 October 9th, 2008 06:57 AM
Having problem share the data between 2 Applicatio prashant.borude BOOK: Beginning SharePoint 2007: Building Team Solutions with MOSS 2007 ISBN: 978-0-470-12449-9 0 September 24th, 2007 04:25 AM
Having problem share the data between 2Application prashant.borude BOOK: Beginning SharePoint 2007: Building Team Solutions with MOSS 2007 ISBN: 978-0-470-12449-9 0 September 20th, 2007 08:49 AM
Backing up a database BigH140 Access 9 August 8th, 2006 09:09 AM
backing up all databases on sql Adam H-W SQL Server 2000 2 October 29th, 2003 01:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.