backup over tcp/ip

Hello,
Is it possible to place the backup on another location via tcp ip?
ThnxThe BOL states you can use a UNC path and I have done this before, you
should be able to specify an IP address and share folder too. I am not in
front of a sql server to test though. You can always use a mapped drive
letter too.
hth
Eric
Samuel wrote:
> Hello,
> Is it possible to place the backup on another location via tcp ip?
> Thnx|||"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:270FDC17-5046-48CF-8E87-BBE46C72F57A@.microsoft.com...
> And SQL will need permissions to the destination resource too. Best if SQL
> Server runs under a domain account.
> The maintenance plan UI does not support UNC paths, but T-SQL does (BACKUP
> database...).
Yes it does. I've set up several backups this way.
However, you ahve to manually type them in, you can't click on the gui to
get it to fill in the box.
> Cheers
> Mike
> "Eric Sabine" wrote:
> > The BOL states you can use a UNC path and I have done this before, you
> > should be able to specify an IP address and share folder too. I am not
in
> > front of a sql server to test though. You can always use a mapped drive
> > letter too.
> >
> > hth
> > Eric
> >
> >
> > Samuel wrote:
> > > Hello,
> > >
> > > Is it possible to place the backup on another location via tcp ip?
> > >
> > > Thnx
> >
> >
> >|||try something like this:
backup database DB1 to disk ='\\remoteserver\f$\backups\DB1_db_200409171500.bck'
remoteserver: the remote server you want to back up to.
f$ : the drive on said remote server.
backups: directory or folder on said drive on said remote server.
DB1_db_200409171500.bck: backup file name with date and time.
"Samuel" <samuel@.hotrmail.com> wrote in message
news:Oo34fH$mEHA.2076@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Is it possible to place the backup on another location via tcp ip?
> Thnx
>|||Hi Greg,
Do you have a example which i could use?
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:RAh2d.42$yg.19@.twister.nyroc.rr.com...
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:270FDC17-5046-48CF-8E87-BBE46C72F57A@.microsoft.com...
> > And SQL will need permissions to the destination resource too. Best if
SQL
> > Server runs under a domain account.
> >
> > The maintenance plan UI does not support UNC paths, but T-SQL does
(BACKUP
> > database...).
> Yes it does. I've set up several backups this way.
> However, you ahve to manually type them in, you can't click on the gui to
> get it to fill in the box.
>
> >
> > Cheers
> > Mike
> >
> > "Eric Sabine" wrote:
> >
> > > The BOL states you can use a UNC path and I have done this before, you
> > > should be able to specify an IP address and share folder too. I am
not
> in
> > > front of a sql server to test though. You can always use a mapped
drive
> > > letter too.
> > >
> > > hth
> > > Eric
> > >
> > >
> > > Samuel wrote:
> > > > Hello,
> > > >
> > > > Is it possible to place the backup on another location via tcp ip?
> > > >
> > > > Thnx
> > >
> > >
> > >
>|||"Samuel" <samuel@.hotrmail.com> wrote in message
news:%23Y27XVLnEHA.3628@.TK2MSFTNGP09.phx.gbl...
> Hi Greg,
> Do you have a example which i could use?
Not sure what you mean by an example. It's tough to show what the graphical
interface will look like in a text forum.
However, if you're using the GUI to setup a maintenance plan to do backups,
when it asks you where to save them to, rather than using the button to pull
up the directory "tree" and drilling down from there, simply type in the UNC
you want to use.
Note, the account SQL Agent runs under MUST have rights to that UNC.
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:RAh2d.42$yg.19@.twister.nyroc.rr.com...
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:270FDC17-5046-48CF-8E87-BBE46C72F57A@.microsoft.com...
> > > And SQL will need permissions to the destination resource too. Best if
> SQL
> > > Server runs under a domain account.
> > >
> > > The maintenance plan UI does not support UNC paths, but T-SQL does
> (BACKUP
> > > database...).
> >
> > Yes it does. I've set up several backups this way.
> >
> > However, you ahve to manually type them in, you can't click on the gui
to
> > get it to fill in the box.
> >
> >
> > >
> > > Cheers
> > > Mike
> > >
> > > "Eric Sabine" wrote:
> > >
> > > > The BOL states you can use a UNC path and I have done this before,
you
> > > > should be able to specify an IP address and share folder too. I am
> not
> > in
> > > > front of a sql server to test though. You can always use a mapped
> drive
> > > > letter too.
> > > >
> > > > hth
> > > > Eric
> > > >
> > > >
> > > > Samuel wrote:
> > > > > Hello,
> > > > >
> > > > > Is it possible to place the backup on another location via tcp ip?
> > > > >
> > > > > Thnx
> > > >
> > > >
> > > >
> >
> >
>|||The other name for this is replication.
Eric Sabine wrote:
> The BOL states you can use a UNC path and I have done this before, you
> should be able to specify an IP address and share folder too. I am not in
> front of a sql server to test though. You can always use a mapped drive
> letter too.
> hth
> Eric
>
> Samuel wrote:
>>Hello,
>>Is it possible to place the backup on another location via tcp ip?
>>Thnx
>
>|||"Adrian Edwards" <a.n.other@.hotmail.com> wrote in message
news:cier3e$edm$3@.sparta.btinternet.com...
> The other name for this is replication.
No, replication is something completely different.
> Eric Sabine wrote:
> > The BOL states you can use a UNC path and I have done this before, you
> > should be able to specify an IP address and share folder too. I am not
in
> > front of a sql server to test though. You can always use a mapped drive
> > letter too.
> >
> > hth
> > Eric
> >
> >
> > Samuel wrote:
> >
> >>Hello,
> >>
> >>Is it possible to place the backup on another location via tcp ip?
> >>
> >>Thnx
> >
> >
> >|||I was being facetious.
Greg D. Moore (Strider) wrote:
> "Adrian Edwards" <a.n.other@.hotmail.com> wrote in message
> news:cier3e$edm$3@.sparta.btinternet.com...
>>The other name for this is replication.
>
> No, replication is something completely different.
>
>>Eric Sabine wrote:
>>
>>The BOL states you can use a UNC path and I have done this before, you
>>should be able to specify an IP address and share folder too. I am not
> in
>>front of a sql server to test though. You can always use a mapped drive
>>letter too.
>>hth
>>Eric
>>
>>Samuel wrote:
>>
>>Hello,
>>Is it possible to place the backup on another location via tcp ip?
>>Thnx
>>
>|||And SQL will need permissions to the destination resource too. Best if SQL
Server runs under a domain account.
The maintenance plan UI does not support UNC paths, but T-SQL does (BACKUP
database...).
Cheers
Mike
"Eric Sabine" wrote:
> The BOL states you can use a UNC path and I have done this before, you
> should be able to specify an IP address and share folder too. I am not in
> front of a sql server to test though. You can always use a mapped drive
> letter too.
> hth
> Eric
>
> Samuel wrote:
> > Hello,
> >
> > Is it possible to place the backup on another location via tcp ip?
> >
> > Thnx
>
>