I need to be able to backup my databases through EM to a network drive. The problem is EM won't recognize any of the network drives. This worked for me in the past but I am now running sp3a and for some reason cannot backup to my remote servers anymore.
Does anyone know how to fix this issue?You should use a UNC name instead of a drive letter... any way..
just type in the UNC name..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kelly" <mavericc@.wepsoft.com> wrote in message
news:DCE35BB4-9F00-483A-ADB1-97F38DDB3075@.microsoft.com...
> I need to be able to backup my databases through EM to a network drive.
The problem is EM won't recognize any of the network drives. This worked
for me in the past but I am now running sp3a and for some reason cannot
backup to my remote servers anymore.
> Does anyone know how to fix this issue?|||Just for the record, trace flag 1807 is not needed to backup to a network
share. The flag is intended to allow SQL Server to use network attached
storage devices for database files as described in MSKB 304261
<http://support.microsoft.com/default.aspx?scid=kb;en-us;304261&Product=sql>
.
As Wayne said earlier in this thread, UNCs can be used. If this isn't
working, the likely cause us that the SQL Server service account lacks
permissions to the share. Note that this needs to be a Windows account
rather than Local System.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ted" <anonymous@.discussions.microsoft.com> wrote in message
news:179E57A3-786D-4CF6-B4D0-8DB9D5C987B6@.microsoft.com...
> If the trace didn't work, and it must be set, then it's permission of the
SQLServer and Agent services. I have a domain account I use and it has the
appropriate permission on the network. I use that same account for mail
notification as well. So:
> 1.) Verify the user starting the services has permission to the network
drive.
> 2.) Set the trace flag on
> 3.) Try it. If it works, you don't need to worry about the reboot. It
knows it wrote to the network once and will do it again. (I've never had a
problem).
> Ted-|||Ah yes. I stand corrected. The trace is for NAS. Thanks for the correction Dan.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment