You are here: Re: Backup Priority level « MsSQL Server « IT news, forums, messages
Re: Backup Priority level

Posted by Shuurai on 12/21/06 14:22

Erland Sommarskog wrote:
> gabe101 (gabe101@gmail.com) writes:
> > My only concern here comes back to my inexperience with transaction
> > logs. Doing a restore through the Enterprise Manager is incredibly
> > simple with a full .BAK file. I've not done a transaction log restore
> > and have been told it's much more complex. I agree with you and Erland
> > here, but given our current situation, a restore from a full backup
> > file and then manually entering the day's transactions may ultimately
> > be just as simple to accomplish.
>
> Note that what I suggested was *not* a transaction log dump, but a
> differential backup. I will have to admit that I've never taken a
> differential backup, nor restored from one, but I can't imagine
> that it's that tricky.

Not tricky at all. Restore the full backup, then restore the diff.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация