Restor Content DataBase(sharepoint)

If you have only content database of share point. You can restore a sharepoint website through this database. you can follow the below steps. First: you should create a new webapp and site collections, the content database name must be the same as which you’ll restore. Second: delete the content database on sql server, then attach the database which you’ll restore. Then you open this link.you maybe the problem which file not found. Third(note): you can remove the content db of that new web app using Central Administration. Then you add the content db once again. OK,the problem has been solved.、

 

http://www.51testing.com/?uid-61184-action-viewspace-itemid-79572

 

 

 

using cmd:

c:/programfiles/commonfiles/microsoftshared/web server extensions/12/bin

Problem1:

1.     stsadm -0 restore –url http://server:3963/ -filename backup123.dat

 

 

error:another site already exists at ‘/’,choose a new url or overwrite this existing one

 

solusion:

Delete this site collection under this application.then excute this cmd again.final it succeed.

 

Problem2:

 

1.     stsadm -0 backup –url http://server:908/ -filename backup123.dat

 

1.     stsadm -0 restore –url http://server:908/ -filename backup123.dat

 

 

 when we backup and restore under the same application.then it errors  with “No content databases are available for this operation”

 

In the Microsoft Site its has been mentioned that to restore the same site collection multiple times, new content databases have to be created. This is because, the globally-unique identifiers (GUID) for lists are preserved in the backup file and reused during restore, but the content database requires list GUIDs to be unique. Therefore, you cannot restore a site collection twice to the same content database, and must instead use a different content database.

 

Solusion:

Create a new application without site collection,then excute this cmd again.Finally it succeed.