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.
Showing posts with label recognize. Show all posts
Showing posts with label recognize. Show all posts
Friday, February 10, 2012
Backup to Network Drive
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 anymor
e.
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?
|||From Query Analyzer:
dbcc traceon (1807)
Then use should be able to use the UNC path.
|||Does the traceflag setting only last until the computer is rebooted
though?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Even after putting the traceflag in it still woulnd't work. When I put
the UNC path in it says unable to verify the existance of backup file
location.
I tell it to use the directory anyway then I get an error cannot open
backup device. Device Error or device offline.
I don't see why it won't work.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||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-
|||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...61&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.
e.
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?
|||From Query Analyzer:
dbcc traceon (1807)
Then use should be able to use the UNC path.
|||Does the traceflag setting only last until the computer is rebooted
though?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Even after putting the traceflag in it still woulnd't work. When I put
the UNC path in it says unable to verify the existance of backup file
location.
I tell it to use the directory anyway then I get an error cannot open
backup device. Device Error or device offline.
I don't see why it won't work.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||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-
|||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...61&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.
Backup to Network Drive
I need to be able to backup my databases through EM to a network drive. Th
e 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 anymor
e.
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?|||From Query Analyzer:
dbcc traceon (1807)
Then use should be able to use the UNC path.|||Does the traceflag setting only last until the computer is rebooted
though?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Even after putting the traceflag in it still woulnd't work. When I put
the UNC path in it says unable to verify the existance of backup file
location.
I tell it to use the directory anyway then I get an error cannot open
backup device. Device Error or device offline.
I don't see why it won't work.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||If the trace didn't work, and it must be set, then it's permission of the SQ
LServer and Agent services. I have a domain account I use and it has the ap
propriate permission on the network. I use that same account for mail notif
ication as well. So:
1.) Verify the user starting the services has permission to the network driv
e.
2.) Set the trace flag on
3.) Try it. If it works, you don't need to worry about the reboot. It kno
ws it wrote to the network once and will do it again. (I've never had a prob
lem).
Ted-|||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/defaul...261&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 correctio
n Dan.
e 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 anymor
e.
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?|||From Query Analyzer:
dbcc traceon (1807)
Then use should be able to use the UNC path.|||Does the traceflag setting only last until the computer is rebooted
though?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Even after putting the traceflag in it still woulnd't work. When I put
the UNC path in it says unable to verify the existance of backup file
location.
I tell it to use the directory anyway then I get an error cannot open
backup device. Device Error or device offline.
I don't see why it won't work.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||If the trace didn't work, and it must be set, then it's permission of the SQ
LServer and Agent services. I have a domain account I use and it has the ap
propriate permission on the network. I use that same account for mail notif
ication as well. So:
1.) Verify the user starting the services has permission to the network driv
e.
2.) Set the trace flag on
3.) Try it. If it works, you don't need to worry about the reboot. It kno
ws it wrote to the network once and will do it again. (I've never had a prob
lem).
Ted-|||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/defaul...261&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 correctio
n Dan.
Subscribe to:
Posts (Atom)