Expert help !

I just want to confirm from you that is this is the good practise if I can
take full backup which size is 4 GB and log backup into another system
instead of same system... right now what I am thinking is the size of the
backup is too larget so the network would be too jam if the full backup
would be take place ? need your idea.
Thanks
Hi,
If you have enough hard disk space, it is always recomended to perform full
database backup in to the local system.
This will complete the backup very fast and will not create network issues.
After the backup process you could
copy the .BAK file to remote machine.
Thanks
Hari
SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:%23snt5iwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
>I just want to confirm from you that is this is the good practise if I can
> take full backup which size is 4 GB and log backup into another system
> instead of same system... right now what I am thinking is the size of the
> backup is too larget so the network would be too jam if the full backup
> would be take place ? need your idea.
> Thanks
>
|||if you can compare then how much would be difference ... 50% delay or 20%
like if you campare to both backup into same machine and backup into another
machine....just for idea.
Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eM55cuwWFHA.2348@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you have enough hard disk space, it is always recomended to perform
full
> database backup in to the local system.
> This will complete the backup very fast and will not create network
issues.[vbcol=seagreen]
> After the backup process you could
> copy the .BAK file to remote machine.
> Thanks
> Hari
> SQL Server MVP
>
> "Joh" <joh@.mailcity.com> wrote in message
> news:%23snt5iwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
can[vbcol=seagreen]
the
>
|||Hi,
That depends up on your Network speed and disk controller in the remote
server. As a trial you could try once by backup the database in your local
server once and do a backup across the network once. This will give you the
exact picture on timing.
Thanks
Hari
SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:uHY2bzwWFHA.2080@.TK2MSFTNGP15.phx.gbl...
> if you can compare then how much would be difference ... 50% delay or 20%
> like if you campare to both backup into same machine and backup into
> another
> machine....just for idea.
> Thanks
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eM55cuwWFHA.2348@.TK2MSFTNGP14.phx.gbl...
> full
> issues.
> can
> the
>