One thing to make sure is that the login running the MSSQLSERVER service
requires rights to create/edit files on the share you are accessing.
Unless you are allowing null shares or guest accounts, that means the
login can't be a local user (i.e., it has to be a domain user account).
-----Original Message-----
From: Erwin Sloboda [mailto:[Email Address Removed]
Sent: Friday, December 19, 2003 9:49 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with backup the remote location
Use unc path
Erwin Sloboda
Database Specialist, Database Services Group
Assante Advisory Services Ltd.
416-535-3792, 416-569-7089
Toronto, ON
-----Original Message-----
From: Josh Daniel [mailto:Josh.[Email Address Removed]
Sent: Friday, December 19, 2003 10:05 AM
To: LazyDBA.com Discussion
Subject: Problem with backup the remote location
I am trying to create a backup device in MS SQL 7 to a remote location.
The remote location is a 2000 server on the same domain as the SQL 7
server. Can anyone help me with this?
Thanks,
Josh
------------------------------------------------------------------------
--
WARNING: All e-mail to or from this address is recorded by Assante and
is subject to archival, monitoring and/or review, by and/or disclosure
to, someone other than the recipient. This message is intended only for
the persons to whom it is addressed. It may contain information that is
privileged and confidential. If you are not the intended recipient,
please contact the sender immediately and delete the e-mail without
reading it or making a copy.
Any distribution, copying, or other use of this e-mail by
a person other than the intended recipient is prohibited. Precautions
have been taken to screen this e-mail for viruses but it may not be
virus free. We are not responsible for any damage that may be caused by
this e-mail. This communication is for information purposes only and is
not an offer to sell or a solicitation of an offer to buy any financial
product, an official confirmation of any transaction or an official
statement of Assante. E-mail transmission cannot be guaranteed to be
secure or error-free.
------------------------------------------------------------------------
--
MS Sql Server LazyDBA home page