Hi,
I've seen a post that he/she has exact same issue like me...
However, I couldn't find any solution for this...
This is the past post that somebody wrote the issue...
---
From: Wayne Antinore - view profile
Date: Tues, Apr 8 2003 3:50 pm
Email: "Wayne Antinore"
Groups: microsoft.public.sqlserver.server
Hi,
I'm using the DMO object to issue a database backup. This worked great when
the application and SQL Server were on the same machine but now I want to
run them distributed from each other. I can connect to a remote DB server
just fine but when I set the .files property on the backup object and try to
take a backup it appears to expect the backup path to be local to the SQL
Server machine. Not where the DMO object is running on my applicaiton
server. Is there a way around this without using a UNC path? I thought I
remembered seeing this on this newsgroup before but I can't find it now.
Thanks,
Wayne Antinore
----
--
One thing I can think of is ...
Once the remote backup is done, move the backup file to the machine DMO
object is running...However, I don't think this is a good soultion.....
Any better or elegant way to solve this issue?
Any method that is provided by DMO to handle this issue?
Thank you in advance.
.........................................................
...TJThe backup job is being performed by the SQL server, not the client
that requests the job be performed. Therefore the path will always be
relative to the server, and if you want to backup to a different
location you'll have to use a unc path.
Cheers
Willsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment