Site Meter Microsoft Office » Blog Archive » Plan for disaster recovery in Project Server 2007

Plan for disaster recovery in Project Server 2007

by Brick ONeil

Backing up by using SQL Server tools

SQL Server backup and recovery tools allow for the greatest versatility in recovering your Office Project Server 2007 deployment after a failure. SQL Server tools have the following advantages:

Using the Full Recovery model for SQL Server databases allows for recovery to the point of failure in the event of a database loss.

Office Project Server 2007 and related databases can be synchronized by using transaction log marking. This allows for database consistency during database recovery.

SQL Server tools have the following disadvantage:

SQL Server procedures can be complex and require a good knowledge of SQL Server itself and SQL Server databases. We recommend a trained SQL Server database administrator be responsible for these procedures.

Which should I use?
Which backup method to use depends on the requirements of your organization and the availability of trained resources to manage the process. SQL Server tools offer the most versatile options for recovery, but they are more complex to use. SharePoint Products and Technologies tools are simple to use, but only allow recovery to the last full or differential backup, meaning there will generally be some data loss. SharePoint Products and Technologies tools also require the system to backed up during a period of inactivity to ensure data consistency across databases.

Use SharePoint Products and Technologies tools if:

You have a deployment which is not in use for several hours, usually at night, when backups can be performed.

You can tolerate data loss of up to twenty-four hours (the time since the last daily backup).

Your organization does not have trained SQL Server database administrators or IT personnel who can manage the processes of using SQL Server tools.


Posted in Project on November 21st, 2008

Link to this Entry

Recent Posts

Related Posts

Leave a Reply


About Microsoft Office

We’ll be discussing Microsoft Office products, the suites, updates and upgrades, tips and tricks. There are wonderful programs that Microsoft has come out with, especially Word, Excel and Outlook. There are programs for everyone out there, from home and student workers, small businesses and corporations. So, keep in contact, watch this space, as the saying goes, contact me with your tips, comments

Microsoft Office Author(s)
    » Brick-ONeil

NAVIGATE

LINKS

CATEGORIES

TOP COMMENTERS

RECENT COMMENTS

SUBSCRIBE

ARCHIVES

Technology Channel Posts

  • How far do you go to be Green?
    Recycle, reduce and reuse are the hallmarks of the "Green Living" lifestyle and ecoists. There are many useful and easy to embrace ideas in going "Green". Such as recycling paper, metals, [...]
  • Expert: Microsoft Earned $1.5B From Vista Capable Program
    An expert has determined that Microsoft may have earned more than US$1 billion from its controversial Windows Vista Capable sticker program, which is still at the center of a class-action suit being [...]
  • Motorola Aura
    This new stainless steel handset is designed after luxury watches and defines artistry in the way mobile units are made and manufactured. The craftsmanship to this is unbelievably distinct. It [...]
  • The New Kids are taking Over: IE Lost Share to Firefox, Safari and Chrome in December
    Web sites saw visitors deserting Microsoft's Internet Explorer browser in favor of Apple's Safari, Mozilla's Firefox and Google's Chrome in December, according to Web analytics company Net [...]
  • A small update to the OneNote Table of Contents Powertoy
    John Guin has an update for OneNote:Over the in the OneNote Discussion Group, Mike made this request for a change to the Table of Contents Powertoy: "I have downloaded and used the TOC power toy. [...]
  • Servers Back Up on 451 Press
    Apologies for no new posts the past two days, the 451 Press Servers were offline due to a glitch. The little hamsters that power the wheels took a rest and are now fully charged and ready to go. [...]
  • Servers Back Up on 451 Press
    Apologies for no new posts the past two days, the 451 Press Servers were offline due to a glitch. The little hamsters that power the wheels took a rest and are now fully charged and ready to go. [...]
  • Happy New Year!
    I wish everyone a Happy New Year! Regular posting will resume this Monday. Thanks for continuing to visit this site. [...]
  • Tough sentences in China over huge piracy ring: Microsoft
    A Chinese court has issued tough sentences to members of a huge software counterfeiting ring, which distributed more than two billion dollars' worth of fake Microsoft goods, the company [...]
  • Office hours: Web life for grownups
    From the Office Hours Blog: Next time you're in a meeting listening to a manager who looks younger than your cat detail your role in your company's Social Media Future (aka Web 2.0), consider this: [...]

 

Hot Off The Press

  • Back-to-Back Fashion Miss for Kate Hudson
    Can you imagine a star donning on a back-to-back fashion miss all for one day? I guess we ought to ask Kate Hudson about that. Why she just deliberately failed to impress the fashion critics [...]
  • John Pelphrey press conference - Texas
    The Razorbacks and No. 7-ranked Longhorns tip off at 8:05 p.m. Tuesday from Bud Walton Arena. [...]
  • Random Wordbank Wednesday
    Hello once again everyone! Welcome to another mid-week random word bank. Unlike the 'contemplating' which prompts you or 'musical Monday' that inspires you, these wordbanks serve as a way to not [...]
  • On The Other Hand...
    The other pathway to knowledge would seem less amenable to logical processes. There are times when we simply 'know' something. Psychology has tried to tell us it's because much of our input is [...]
  • Guest Author Sandi Kahn Shelton on Finding Time to Write
    Sandi Kahn Shelton, author of 'Kissing Games of the World' is joining us here today to talk about a facet of our focus for the beginning of 2009 - getting that novel written. I hope you'll join me in [...]
  • Gimmicks, False Marketing, and Weight Loss
    After my experience of violently reacting to metformin (a very rare reaction, I’m told), saying that I’m ‘cautious’ about weight loss products is a huge understatement. Today I found a [...]
  • Anne Hathaway at the Palm Springs International Film Festival Awards Gala
    Since appearing as Mia Thermopolis in Disney’s The Princess Diaries, I can honestly say that I am an Anne Hathaway fan. However, since I promised for the New Year that Celebrity Fashion [...]
  • John Corbett....
    Technorati Tags: John Corbett,Chris in the Morning,Chris Stevens,Northern Exposure,Carry Bradshaw,Aiden,Sex and the City,Nia Vardalos,My Big Fat Greek Wedding,Bo Derek,The Wonder [...]
  • One Size Fits All
    I remember one Christmas, way too many years ago, when all I wanted was a baton. I was about 8, and wanted to be a majorette in the worst way. My Dad told me there was no way I was going to get a [...]
  • The Astrology of Fixed Stars: Much Ado About Algol
    January 7, 2009 Hello My chart is a bit confusing. I hope if you have any insight on it. It's full of good aspects (sun-moon trine, jupiter-saturn conjunction, moon conjunct midheaven and leo [...]