SQL Server considerations with Farm restore in SharePoint 2007

We have used the farm backup facility in SharePoint 2007 Central Administration to perform a backup of our SharePoint Farm, including Project Server 2007. We are wanting to restore this to another environment, which is fine, however, what are the considerations required for SQL Server with relation to logs etc.

Does anyone know how this process actually works under the hood?
cooperal31Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Easiest way to restore SharePoint is to backup content databases. Create your new environment with the web applications and content databases.  Restore your SQL database backups after you take the SharePoint DBS offline and after the restore, bring the databases back online.   Refer to following link for more information:

http://technet.microsoft.com/en-us/library/cc671616(v=office.12).aspx
0
Yagya ShreeCommented:
Hi, Please check below technet post, it talks in details about farm restore on different environment from sharepoint as well as SQL prospective.

Move Sharepoint 2007 Farm to another server
http://social.technet.microsoft.com/Forums/sharepoint/en-US/000f3b73-8128-449b-8159-5d448da12655/move-sharepoint-2007-farm-to-another-server?forum=sharepointadminlegacy
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.