Remote Database backup/restore

Anyone know if this can be done over TCP/IP connection?
Thanks in advance..
-BBHi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > Anyone know if this can be done over TCP/IP connection?
> >
> > Thanks in advance..
> >
> > -BB
> >
> >
>|||Correct. SQL Server does the backup, not the client from where you run the client app to send the BACKUP
commend to SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be seen
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Yes, You can do that. All you have to do is , create a Alias for the SQL
> > server using TCP/IP protocol, Ip address and Port number.
> > Using that Alias name register the SQL server in enterprise manager or use
> > Query Analyzer to connect.
> >
> > After that you could run the BACKUP DATABASE command to backup and RESTORE
> > DATABASE command to restore the database.
> >
> > To backup the file remotely or restore the file from remote locaton you
> have
> > to start the SQL Server service
> > using an Domain OS user which got write access to the remote share.
> >
> > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> sercice--
> > Double click and select the "Log on" option.
> > There you give a Valid Domain OS user and password to start the service.
> Now
> > stop and start the MSSQL Serevr service.
> >
> > Note: That domain user should have previlages in the remote share to write
> > the file as well as prev. to start the SQL server.
> >
> > After this you try to execute the Backup database command in Query
> > Analyzer:-
> >
> >
> > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> > init ( With init will overwrite the backup file every time)
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > Anyone know if this can be done over TCP/IP connection?
> > >
> > > Thanks in advance..
> > >
> > > -BB
> > >
> > >
> >
> >
>|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > Hi Hari,
> >
> > I had gotten this already. So the only file systems that can EVER be
seen
> > are the ones available to the Server .. no matter where you execute the
> > BACKUP from? For example if I want to execute the backup from a
remote
> > site, and put the dump file on client that is executing the BACKUP, then
I
> > MUST have a network share enabled on the remote client computer?
> >
> > Many thnx again,
> >
> > -BB
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> > news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > Yes, You can do that. All you have to do is , create a Alias for the
SQL
> > > server using TCP/IP protocol, Ip address and Port number.
> > > Using that Alias name register the SQL server in enterprise manager or
use
> > > Query Analyzer to connect.
> > >
> > > After that you could run the BACKUP DATABASE command to backup and
RESTORE
> > > DATABASE command to restore the database.
> > >
> > > To backup the file remotely or restore the file from remote locaton
you
> > have
> > > to start the SQL Server service
> > > using an Domain OS user which got write access to the remote share.
> > >
> > > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> > sercice--
> > > Double click and select the "Log on" option.
> > > There you give a Valid Domain OS user and password to start the
service.
> > Now
> > > stop and start the MSSQL Serevr service.
> > >
> > > Note: That domain user should have previlages in the remote share to
write
> > > the file as well as prev. to start the SQL server.
> > >
> > > After this you try to execute the Backup database command in Query
> > > Analyzer:-
> > >
> > >
> > > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat'
with
> > > init ( With init will overwrite the backup file every time)
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > > Anyone know if this can be done over TCP/IP connection?
> > > >
> > > > Thanks in advance..
> > > >
> > > > -BB
> > > >
> > > >
> > >
> > >
> >
> >
>