Backup of databases

Hi
I would like to know if is possible to do a traditional backup to tape
every day as full database and also remote backup. The remote backup as the
comunications are not very good should be the first time full but the other
days should be differential. Is possible to have both backups mode as I
explain ?. Or only will I have one method to do a backup?. I never work with
SQL and I don't know if this configuration could be done.
Thanks in advance> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup.
Yes. You do two backups, one to tape, the other to disk on a share on anothe
r machine (or locally
and then copying the file).

>The remote backup as the
> comunications are not very good should be the first time full but the othe
r
> days should be differential. Is possible to have both backups mode as I
> explain ?
YEs, but there's no automation that does it for you. You have to create your
own scripts/jobs to
handle this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Juanchu" <Juanchu@.discussions.microsoft.com> wrote in message
news:6B96D8B2-83C5-415B-830C-C85B043FD4E4@.microsoft.com...
> Hi
> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup. The remote backup as th
e
> comunications are not very good should be the first time full but the othe
r
> days should be differential. Is possible to have both backups mode as I
> explain ?. Or only will I have one method to do a backup?. I never work wi
th
> SQL and I don't know if this configuration could be done.
> Thanks in advance