Using SQL backup and restore for MOSS

Hi,

• Back Up and Restore the content database to a new Sql server
• In Central Administration page
• Go to Application Management and Click on Create or extend web application.
• Therein Create a new web application. Once application is created don’t create Site Collection.
• Now again go back to Application Management.
• Therein click Content Databases
• Change the web application to point to web application you just created.
• Remove the default content database created while creating the web application.
• Then click on Add a content database
• Specify the Database Server where the content database was restored and in database name specify the name of the content database.
• The site should get restored properly.

Check out this good information

http://blah.winsmarts.com/2007-10-Backup_and_Restore_Strategies_in_MOSS_2007.aspx

Bye

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology ! View all posts by Nishant Rana