Hi, all
I am trying to do the data differential databackup daily and full backup
during the weekend.
Log shipping remain the same as usual.
There is anything that I should be aware of before I chnage the backup
method.
It takes too long to have full data backup every night.
Thanks,Diff backup of the source database does not affect log shipping in any way.
So, just make sure you
have thought about disaster recovery, number of backup generations and that
you understand the
concept of database, diff and transaction log backups (which are pretty simp
le).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:e0FEv70JGHA.2012@.TK2MSFTNGP14.phx.gbl...[v
bcol=seagreen]
> Hi, all
> I am trying to do the data differential databackup daily and full backup d
uring the weekend.
> Log shipping remain the same as usual.
> There is anything that I should be aware of before I chnage the backup met
hod.
> It takes too long to have full data backup every night.
> Thanks,
>[/vbcol]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment