I am trying to establish a Database Maintenance plan for our SQL server and when I choose
Database Maintenance Plan
Complete Backup Tab
Under choose directory when I choose the (...) icon to choose a directory only the C and D drive of the server appears, I do not see the network drives.
I resolved this in the past but forgot how to.
Thanks
Jeffrey
What I used to do in 6.5 was run a scheduled task that had the ID that SQL was running under to map the network drive. I have not had a need to try this in 2k but it is worth a shot.
Jeff
MCDBA, MCSE+I
|||Not too sure if you can do this on Database Maintenance Plans
Put you can create a Backup device pointing to a Network drive and create
backup jobs to that network device(s)
Regards
J
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks
|||Type in the UNC name of the share. Make sure the SQL server service account
has permissions to that share.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks
Showing posts with label plan. Show all posts
Showing posts with label plan. Show all posts
Friday, March 30, 2012
Network drives not available on Database Maintenance
I am trying to establish a Database Maintenance plan for our SQL server and
when I choose
Database Maintenance Plan
Complete Backup Tab
Under choose directory when I choose the (...) icon to choose a directory on
ly the C and D drive of the server appears, I do not see the network drives.
I resolved this in the past but forgot how to.
ThanksJeffrey
What I used to do in 6.5 was run a scheduled task that had the ID that SQL w
as running under to map the network drive. I have not had a need to try thi
s in 2k but it is worth a shot.
Jeff
MCDBA, MCSE+I|||Not too sure if you can do this on Database Maintenance Plans
Put you can create a Backup device pointing to a Network drive and create
backup jobs to that network device(s)
Regards
J
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks|||Type in the UNC name of the share. Make sure the SQL server service account
has permissions to that share.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks
when I choose
Database Maintenance Plan
Complete Backup Tab
Under choose directory when I choose the (...) icon to choose a directory on
ly the C and D drive of the server appears, I do not see the network drives.
I resolved this in the past but forgot how to.
ThanksJeffrey
What I used to do in 6.5 was run a scheduled task that had the ID that SQL w
as running under to map the network drive. I have not had a need to try thi
s in 2k but it is worth a shot.
Jeff
MCDBA, MCSE+I|||Not too sure if you can do this on Database Maintenance Plans
Put you can create a Backup device pointing to a Network drive and create
backup jobs to that network device(s)
Regards
J
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks|||Type in the UNC name of the share. Make sure the SQL server service account
has permissions to that share.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks
Wednesday, March 28, 2012
Network Backup
I want to backup up one of my Database running on SQL
Server 2000 on to
another machine on the network. I already have a Database
Maintenace plan
set up which backs up the database on the same box. But
now I want to back
it up on a different machine as a disaster recovery
measure. Under the
Enterprise Managerin SQL Server I only have the option to
back it up on
a device and cant seem to do it over the Network. Anyone
has any ideas on
how to do this without using a 3rd party software?
I was told to just specify the UNC path
(\\servername\share for example) and
make sure the
account used by the sql server service has privileges on
that network share
but when I try to do that the Database Maintanence plan
chucks back with an
error "The complete database backup
directory"\\servername\share" is
invalid. Are you sure this is what you want?"
I havent actually tried clicking YES to that as yet...is
it really an error
message? I have also looked at the following article
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q304261
this article talks about turning on
trace flag 1807 to by pass the default setting of not
being able to create a
database file on a mapped or UNC network location.
Im new to SQL Server so havent got a clue where to turn on
these flags from.
Im assuming its a commandline option, but where to do it
from Iam
stuck...will anyone will be able to help me with this?
Thanks in advance
AdnanHi
You can use a UNC as the filename or create a device that uses one.
John
"Adnan" <adnan@.clara.net> wrote in message
news:070f01c354fc$f7dea040$a101280a@.phx.gbl...
> I want to backup up one of my Database running on SQL
> Server 2000 on to
> another machine on the network. I already have a Database
> Maintenace plan
> set up which backs up the database on the same box. But
> now I want to back
> it up on a different machine as a disaster recovery
> measure. Under the
> Enterprise Managerin SQL Server I only have the option to
> back it up on
> a device and cant seem to do it over the Network. Anyone
> has any ideas on
> how to do this without using a 3rd party software?
> I was told to just specify the UNC path
> (\\servername\share for example) and
> make sure the
> account used by the sql server service has privileges on
> that network share
> but when I try to do that the Database Maintanence plan
> chucks back with an
> error "The complete database backup
> directory"\\servername\share" is
> invalid. Are you sure this is what you want?"
> I havent actually tried clicking YES to that as yet...is
> it really an error
> message? I have also looked at the following article
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q304261
> this article talks about turning on
> trace flag 1807 to by pass the default setting of not
> being able to create a
> database file on a mapped or UNC network location.
> Im new to SQL Server so havent got a clue where to turn on
> these flags from.
> Im assuming its a commandline option, but where to do it
> from Iam
> stuck...will anyone will be able to help me with this?
> Thanks in advance
> Adnan
>|||Make sure you set the destination folder on the other server to allow
sharing.
Otherwise, the folder will not appear available for access.
"Adnan" <adnan@.clara.net> wrote in message
news:070f01c354fc$f7dea040$a101280a@.phx.gbl...
> I want to backup up one of my Database running on SQL
> Server 2000 on to
> another machine on the network. I already have a Database
> Maintenace plan
> set up which backs up the database on the same box. But
> now I want to back
> it up on a different machine as a disaster recovery
> measure. Under the
> Enterprise Managerin SQL Server I only have the option to
> back it up on
> a device and cant seem to do it over the Network. Anyone
> has any ideas on
> how to do this without using a 3rd party software?
> I was told to just specify the UNC path
> (\\servername\share for example) and
> make sure the
> account used by the sql server service has privileges on
> that network share
> but when I try to do that the Database Maintanence plan
> chucks back with an
> error "The complete database backup
> directory"\\servername\share" is
> invalid. Are you sure this is what you want?"
> I havent actually tried clicking YES to that as yet...is
> it really an error
> message? I have also looked at the following article
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q304261
> this article talks about turning on
> trace flag 1807 to by pass the default setting of not
> being able to create a
> database file on a mapped or UNC network location.
> Im new to SQL Server so havent got a clue where to turn on
> these flags from.
> Im assuming its a commandline option, but where to do it
> from Iam
> stuck...will anyone will be able to help me with this?
> Thanks in advance
> Adnan
>sql
Server 2000 on to
another machine on the network. I already have a Database
Maintenace plan
set up which backs up the database on the same box. But
now I want to back
it up on a different machine as a disaster recovery
measure. Under the
Enterprise Managerin SQL Server I only have the option to
back it up on
a device and cant seem to do it over the Network. Anyone
has any ideas on
how to do this without using a 3rd party software?
I was told to just specify the UNC path
(\\servername\share for example) and
make sure the
account used by the sql server service has privileges on
that network share
but when I try to do that the Database Maintanence plan
chucks back with an
error "The complete database backup
directory"\\servername\share" is
invalid. Are you sure this is what you want?"
I havent actually tried clicking YES to that as yet...is
it really an error
message? I have also looked at the following article
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q304261
this article talks about turning on
trace flag 1807 to by pass the default setting of not
being able to create a
database file on a mapped or UNC network location.
Im new to SQL Server so havent got a clue where to turn on
these flags from.
Im assuming its a commandline option, but where to do it
from Iam
stuck...will anyone will be able to help me with this?
Thanks in advance
AdnanHi
You can use a UNC as the filename or create a device that uses one.
John
"Adnan" <adnan@.clara.net> wrote in message
news:070f01c354fc$f7dea040$a101280a@.phx.gbl...
> I want to backup up one of my Database running on SQL
> Server 2000 on to
> another machine on the network. I already have a Database
> Maintenace plan
> set up which backs up the database on the same box. But
> now I want to back
> it up on a different machine as a disaster recovery
> measure. Under the
> Enterprise Managerin SQL Server I only have the option to
> back it up on
> a device and cant seem to do it over the Network. Anyone
> has any ideas on
> how to do this without using a 3rd party software?
> I was told to just specify the UNC path
> (\\servername\share for example) and
> make sure the
> account used by the sql server service has privileges on
> that network share
> but when I try to do that the Database Maintanence plan
> chucks back with an
> error "The complete database backup
> directory"\\servername\share" is
> invalid. Are you sure this is what you want?"
> I havent actually tried clicking YES to that as yet...is
> it really an error
> message? I have also looked at the following article
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q304261
> this article talks about turning on
> trace flag 1807 to by pass the default setting of not
> being able to create a
> database file on a mapped or UNC network location.
> Im new to SQL Server so havent got a clue where to turn on
> these flags from.
> Im assuming its a commandline option, but where to do it
> from Iam
> stuck...will anyone will be able to help me with this?
> Thanks in advance
> Adnan
>|||Make sure you set the destination folder on the other server to allow
sharing.
Otherwise, the folder will not appear available for access.
"Adnan" <adnan@.clara.net> wrote in message
news:070f01c354fc$f7dea040$a101280a@.phx.gbl...
> I want to backup up one of my Database running on SQL
> Server 2000 on to
> another machine on the network. I already have a Database
> Maintenace plan
> set up which backs up the database on the same box. But
> now I want to back
> it up on a different machine as a disaster recovery
> measure. Under the
> Enterprise Managerin SQL Server I only have the option to
> back it up on
> a device and cant seem to do it over the Network. Anyone
> has any ideas on
> how to do this without using a 3rd party software?
> I was told to just specify the UNC path
> (\\servername\share for example) and
> make sure the
> account used by the sql server service has privileges on
> that network share
> but when I try to do that the Database Maintanence plan
> chucks back with an
> error "The complete database backup
> directory"\\servername\share" is
> invalid. Are you sure this is what you want?"
> I havent actually tried clicking YES to that as yet...is
> it really an error
> message? I have also looked at the following article
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q304261
> this article talks about turning on
> trace flag 1807 to by pass the default setting of not
> being able to create a
> database file on a mapped or UNC network location.
> Im new to SQL Server so havent got a clue where to turn on
> these flags from.
> Im assuming its a commandline option, but where to do it
> from Iam
> stuck...will anyone will be able to help me with this?
> Thanks in advance
> Adnan
>sql
Subscribe to:
Posts (Atom)