Friday, February 10, 2012

Backing up to a Remote machine in EM

I need to backup my databases to a remote server. The
problem is Enterprise manager will not recognize a UNC
address. Is there a way I can permanently change this
without just using trace flags.
I am running sql server 2000 with sp3a.
Any suggestions
Make mapped network drive on your machine. For what trace flags are you
talking?
Bojidar Alexandrov
"Kelly" <mavericc@.wepsoft.com> wrote in message
news:830101c431ea$54a0a920$a301280a@.phx.gbl...
> I need to backup my databases to a remote server. The
> problem is Enterprise manager will not recognize a UNC
> address. Is there a way I can permanently change this
> without just using trace flags.
> I am running sql server 2000 with sp3a.
> Any suggestions
|||Mapped drives are not recognized by Enterprise manager either.
I was refering to traceflag 1807.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Have the ID that SQL agent is running under map the drive letter then try
and connect to it.
Jeff Duncan
MCDBA, MCSE+I
"Kelly P" <mavericc@.wepsoft.com> wrote in message
news:%23pCT%23dgMEHA.1468@.TK2MSFTNGP12.phx.gbl...
>
> Mapped drives are not recognized by Enterprise manager either.
> I was refering to traceflag 1807.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment