Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amit.2601
Starting Member
8 Posts |
 Posted - 2009-11-25 : 04:46:25
|
| I have to perform logshipping in two server,i have used sql server 2005 in built tool,after completion of logshipping via wizard ,i found three jobs one back up in primary server while two in secondary named copy and restore.backup job of primary server runs properly and copy job on secondary server failed by showing following error --- *** Error: The given path's format is not supported.(mscorlib) ***Type in Job is operating system (cmdexec)sql server agent accountquery used is - -"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqllogship.exe" -Copy 39D79FE1-469D-4ABE-B9C9-25A5BD586AC4 -server OXITESTSERPlease suggestAmit |
|
|
support.sql
Starting Member
15 Posts |
Posted - 2009-11-29 : 11:17:19
|
| HiIt looks like the destination path where the files has to be copied is wrong, Could you give us more info about the parameters used (Local directory, remote directory and the security as well in both servers?SNMTry Free Microsoft SQL Server Data Collector & Performance Monitor.http://www.analyticsperformance.com@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector |
 |
|
|
|
|
|
problem in logshipping