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

No comments:

Post a Comment