Re: DTS

From: Noorali Issani (naissani_at_softhome.net)
Date: 03/06/04 

Date: Sat, 6 Mar 2004 09:41:30 +0500

Hari, if u don't mind could you tell me how can I take the backup of remote
server from local server through OSQL and how I make the job that to restore
that remoted backup file into locally through osql. I want to make it
automate

thanks in advance

Noor

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:#ICbPdqAEHA.2808@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Where is your Remote database Located, Is that database assesible using
SQL
> server tools (Enterprise manager , Query Analyzer ..). If yes then you can
> automate the steps which I mentioned using SQL Agent -- Jobs.
>
> How to do..
>
> 1. From Local server execute the BACKUP database of your remote server
using
> OSQL
> 2. Step 1 will backup the database backup file to local server
> 3. Run a Restore database command using OSQL command in local SQL server.
>
> Above steps can be automated using SQL Agent -- Jobs.
>
> DTS will not be a ideal solution if the data size is huge.
>
> Thanks
> Hari
> MCDBA
>
>
>
>
>
>
>
>
>
> "Noorali Issani" <naissani@softhome.net> wrote in message
> news:ecZXQOpAEHA.3400@tk2msftngp13.phx.gbl...
> > Hari you are very right but I want the remote database locally which
> should
> > fully automate, through DTS I can fulfill my task, like I will make one
> job
> > which will execute that package and that package will copy the remote
> > database locally... That's my point of view.. if you have any idea then
> > please let me know regarding this..
> >
> > Thanks
> > Noor
> >
> > "Mario Splivalo" <majk@fly.srk.fer.hr> wrote in message
> > news:slrnc4gcjk.91j.majk@fly.srk.fer.hr...
> > > On 2004-03-05, Hari <hari_prasad_k@hotmail.com> wrote:
> > > > Hi,
> > > >
> > > > If you need to transfer the entire database from remote to local,
the
> > best
> > > > suggested way is not to use DTS, rather use the below methods,
> > > >
> > > > Method - 1
> > > >
> > > > a. Detach the database (SP_DETACH_DB dbname)
> > > > b. Copy the MDF and LDF to LOcal server
> > > > c. Attach the database (SP_ATTCHDB
> > > > dbname,'mdffilephysicalname','ldffilephysicalname'
> > >
> > > This won't work if the database is published for replication. But, you
> > could
> > > stop the SQL server, copy the files, and then start the SQL server
back.
> > > After that, attach the copies to the remote database.
> > >
> > > Mike
> > > --
> > > "I can do it quick. I can do it cheap. I can do it well. Pick any
two."
> > >
> > > Mario Splivalo
> > > msplival@jagor.srce.hr
> >
> >
>
>

Relevant Pages

  • Re: SQL 2005 Express Connection Problem
    ... sql2005 support auto attaching a database in the connect string. ... The remote site is not a company ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Am I on the right track here?
    ... I have an Access 2002 database on a Windows 2000 server at my home office. ... At two remote offices I want at least 2 people at EACH of those offices to ... I have used synchronization in the past with laptops doing work in the field ...
    (microsoft.public.access.replication)
  • Re: Datapump and read only database
    ... You can invoke the datapump utilities from a remote server, ... on google that datapumping a read only database remotely is possible though. ... This is because Data Pump can't create the necessary master table or create external tables on a read only database. ... The above will still create the master table in the "remote" database, which if it is read-only, will result in an error. ...
    (comp.databases.oracle.server)
  • Re: Access Database becoming corrupt
    ... broken remotely or they go home on LAN and the server needs restarting etc. ... HP switch, 1 gig connection to server, 100mb to clients. ... Hired vendor to create inventory and sales database in ms-access. ... Vendor said he lost remote connection to our system, ...
    (microsoft.public.windows.server.sbs)
  • Re: configuration settings question
    ... It should give you an idea how to separate the server and client code. ... > My question relates to accessing configuration info from the remote object. ... look into a medical database, ...
    (microsoft.public.dotnet.framework.remoting)
Loading