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
Thanks nishant ..
sfsfasfasf