Solved

SQL 2005 Log shipping error - can not find network path

Posted on 2009-07-15
6
503 Views
Last Modified: 2012-05-07
Hello

wondering if anyone out there is SQL land can help with this issue.  i am setting up log shipping between two databases and i receive the error below.  Googlling every possible solution, i first went from two servers that were mismatched on authentication (now corrected) to this.  documentation on the internet states that the network service should have read and write permission on the secondary sql machine.  i have made these changes and still  a no go.so i am at wits end.  

the help link from Microsoft does not help at all :(

please help

OS - Windows Server 2003
SQL version - 2005 standard

- Backing up primary database [STLNTDB] (Error)

Messages

SQL Server Management Studio could not backup database 'STLNTDB' (Microsoft SQL Server Management Studio)
 

------------------------------

ADDITIONAL INFORMATION:
 

Backup failed for Server 'SCMCTP'.  (Microsoft.SqlServer.Smo)
 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476
 

------------------------------
 

System.Data.SqlClient.SqlError: Cannot open backup device 'T:\BACKUP\STLNTDB.bak'. Operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&LinkId=20476

 
 

- Restoring backup to secondary database [SCMCTP-BAK].[STLNTDB] (Stopped)
 

- Saving secondary destination configuration [SCMCTP-BAK].[STLNTDB] (Stopped)
 

- Saving primary backup setup (Stopped)
 

- Saving Monitor configuration (Stopped)
 

- Rolled Back (Success)

Open in new window

0
Comment
Question by:johnkesoglou
  • 3
  • 2
6 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
Comment Utility
did u restart  the services after changing the authentication
0
 

Author Comment

by:johnkesoglou
Comment Utility
yes - each time i made the change
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
Comment Utility
Did you check the eventviewer / sqlError /sqlServerAgent error log, sometimes those can contain more detailed info.. also try backing up to a different path
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 250 total points
Comment Utility
Are you on a domain?  If so try making the services run under a domain acct that has access to the shares
0
 

Author Comment

by:johnkesoglou
Comment Utility
should i jsut create an account for SQL in the domain and allow it to run the service?  will this have any effect on the other SQL services? would it be prudent to allow the new SQL account to run the other services?
0
 

Author Comment

by:johnkesoglou
Comment Utility
ok -so i got the permissions working but now i receive an error telling me that there isn't enough disk space.  in the log shipping menu, i am pointing the copied database to the larger volume.  do i need to just copy the database to the destination server (server B) and initialize it there (this way i can point the databaase to the larger volume?)

Server A has 3 partitions,
Partition 1 = 1.6 GB remaining
partition 2 = 130 GB
partition 3 = 100 GB

Server b has 3 partitions,
Partition 1 = 1.3 GB remaining
partition 2 = 130 GB
partition 3 = 100 GB
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Need Counts 11 40
SQL Connection (Error 18456) 14 29
MSSQL Frequency of Years From Days Field 2 11
Access Migration to Sql Server 2 18
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now