Backup

Question:
Our Production Database is located off-site hosted by a 3rd party.
I have SQL server installed in our local site. I want to have a backup
copy of the Database from what is on Production located locally on
an ongoing basis. I don't want the DB that is located locally to be
used in anyway by the users. I just want to be sure I have a copy
of the DB at our local office just in case anything happens. I sort
of want to have a DB that mirrors the production site and also a
TEST DB for testing purposes locally.
I'm curious of the best way to go about this. Is it via backup and restore
or some sort of replication solution.
Thanks,
GeorgeI'd go for backup/restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"george" <roberts_g@.marranohomes.com> wrote in message news:eRJ0D6oNEHA.3380@.TK2MSFTNGP11.phx.gbl...
> Question:
> Our Production Database is located off-site hosted by a 3rd party.
> I have SQL server installed in our local site. I want to have a backup
> copy of the Database from what is on Production located locally on
> an ongoing basis. I don't want the DB that is located locally to be
> used in anyway by the users. I just want to be sure I have a copy
> of the DB at our local office just in case anything happens. I sort
> of want to have a DB that mirrors the production site and also a
> TEST DB for testing purposes locally.
> I'm curious of the best way to go about this. Is it via backup and restore
> or some sort of replication solution.
> Thanks,
> George
>
>|||Can I run it as a JOB. The DB use to be in Access we just migrated over to
SQL
server. I use to schedule a copy of the DB, via FTP, from the 3rd party
hosting server like
every 4 hours so that I had a fresh copy of the DB locally. Just curious
how I
do that with SQL server.
I basically just want to feel safe that I have a relatively current copy of
the DB stored
locally. Just in case some unforeseen event happens with our ISP' Like
they forgot
to do backups, or their site goes down, etc. ONCE, they were having a
problem with
their server and took our server off the backup routine and forgot to put it
back in. I
don't think it will happen again, but one never knows. I'd rather be sure
that I have
a copy in case they don't.
Just trying to figure out the best solution to ensure we have a copy stored
locally. Being
this DB is hosted remotely can you backup to a remote location? The 3rd
party DB server
is a shared DB server so other companies also have their DBs hosted on this
server.
Thanks for any help.
George
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oq2a27oNEHA.3492@.TK2MSFTNGP10.phx.gbl...
> I'd go for backup/restore.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "george" <roberts_g@.marranohomes.com> wrote in message
news:eRJ0D6oNEHA.3380@.TK2MSFTNGP11.phx.gbl...
> > Question:
> >
> > Our Production Database is located off-site hosted by a 3rd party.
> > I have SQL server installed in our local site. I want to have a backup
> > copy of the Database from what is on Production located locally on
> > an ongoing basis. I don't want the DB that is located locally to be
> > used in anyway by the users. I just want to be sure I have a copy
> > of the DB at our local office just in case anything happens. I sort
> > of want to have a DB that mirrors the production site and also a
> > TEST DB for testing purposes locally.
> >
> > I'm curious of the best way to go about this. Is it via backup and
restore
> > or some sort of replication solution.
> >
> > Thanks,
> > George
> >
> >
> >
>|||> Can I run it as a JOB.
Sure. Just read up on backup and restore in books online, determine whether you want to go for only db backups
or both db backups and log backups. Then create your job(s) with the desired commands and frequency.
You could either use DTS, which has built-in support for FTP and combine DTS with SQL Command job steps. Then
schedule the DTS task in SQL Server agent.
Or use SQL Agent directly and combine TSQL with CMDExec (from where you run FTP.EXE or similar) tasks.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"george" <roberts_g@.marranohomes.com> wrote in message news:OrJ9lHpNEHA.2480@.tk2msftngp13.phx.gbl...
> Can I run it as a JOB. The DB use to be in Access we just migrated over to
> SQL
> server. I use to schedule a copy of the DB, via FTP, from the 3rd party
> hosting server like
> every 4 hours so that I had a fresh copy of the DB locally. Just curious
> how I
> do that with SQL server.
> I basically just want to feel safe that I have a relatively current copy of
> the DB stored
> locally. Just in case some unforeseen event happens with our ISP' Like
> they forgot
> to do backups, or their site goes down, etc. ONCE, they were having a
> problem with
> their server and took our server off the backup routine and forgot to put it
> back in. I
> don't think it will happen again, but one never knows. I'd rather be sure
> that I have
> a copy in case they don't.
> Just trying to figure out the best solution to ensure we have a copy stored
> locally. Being
> this DB is hosted remotely can you backup to a remote location? The 3rd
> party DB server
> is a shared DB server so other companies also have their DBs hosted on this
> server.
> Thanks for any help.
> George
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oq2a27oNEHA.3492@.TK2MSFTNGP10.phx.gbl...
> > I'd go for backup/restore.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "george" <roberts_g@.marranohomes.com> wrote in message
> news:eRJ0D6oNEHA.3380@.TK2MSFTNGP11.phx.gbl...
> > > Question:
> > >
> > > Our Production Database is located off-site hosted by a 3rd party.
> > > I have SQL server installed in our local site. I want to have a backup
> > > copy of the Database from what is on Production located locally on
> > > an ongoing basis. I don't want the DB that is located locally to be
> > > used in anyway by the users. I just want to be sure I have a copy
> > > of the DB at our local office just in case anything happens. I sort
> > > of want to have a DB that mirrors the production site and also a
> > > TEST DB for testing purposes locally.
> > >
> > > I'm curious of the best way to go about this. Is it via backup and
> restore
> > > or some sort of replication solution.
> > >
> > > Thanks,
> > > George
> > >
> > >
> > >
> >
> >
>