.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

How to Specify Content Database for a Site Collection Restore from Backup

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint
 
Hello,

I have prepared code that first creates a new Content Database within a specified Web Application, then restores a Site Collection backup to that same Web Application.  Unfortunately, the Restore doesn't provide an option to select the Content Database that was just created.  So, is there something that I might do to ensure that the Site Collection gets restored to the Content Database of my choice, programmatically?  If not, is there something I can do to change the Content Database for the newly restored Site Collection?  All ideas would be appreciated.

Thank you,

Doug


View Complete Post


More Related Resource Links

backup and restore site collection

  

 

I'm just trying to move a site collection to a different server (to a virtual machine). I used the backup and restore feature in central administration but I'm not able to view the site on the new server. Is there some step I am missing during this migration?

 

Thank you


Delete a Site Collection without a Content database

  

I have a site collection whose content database has been deleted with no backup. Now I want to delete the site collection and i get what seems to be a sql login error. I know the account I am using has enough access to the sql server (used this account to install sharepoint). I am guessing it is complaining because it can't find the database.

Remove-SPSite : Cannot open database "WSS_Content_Database" requested by the lo
gin. The login failed.
Login failed for user 'DOMAIN\PowerfulAccount'.
At line:1 char:14
+ Remove-SPSite <<<<  https://sitename.domain.com/mysite/username
    + CategoryInfo          : InvalidData: (Microsoft.Share...mdletRemoveSite:
   SPCmdletRemoveSite) [Remove-SPSite], SqlException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRemoveSi
   te

I used the Remove-SPSite <URL of site to delete> command.

Any ideas?

Thanks, Berney


Delete a Site Collection without a Content database

  

I have a site collection whose content database has been deleted with no backup. Now I want to delete the site collection and i get what seems to be a sql login error. I know the account I am using has enough access to the sql server (used this account to install sharepoint). I am guessing it is complaining because it can't find the database.

Remove-SPSite : Cannot open database "WSS_Content_Database" requested by the lo
gin. The login failed.
Login failed for user 'DOMAIN\PowerfulAccount'.
At line:1 char:14
+ Remove-SPSite <<<<  https://sitename.domain.com/mysite/username
    + CategoryInfo          : InvalidData: (Microsoft.Share...mdletRemoveSite:
   SPCmdletRemoveSite) [Remove-SPSite], SqlException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRemoveSi
   te

I used the Remove-SPSite <URL of site to delete> command.

Any ideas?

Thanks, Berney


few sites are missing after taking backup and restore the content database

  

Hi All,

We have taken the backup of content database and restored it in the new server, after that attached the content database on sharepoint central admin, but few sites are missing after this. when checked the database server Number of records are matching in both the servers content database and also the data is matching, but still we are missing few sites. Do we need to do any specific change in sharepoint or database?


How to Deploy MOSS Site Collection using backup/restore with DB attach

  
Can anyone give pointers on Deploying Moss Sites from Development Environment to Production Envirnment Using backup/restore with DB attach?? TIA
Thanks, Devi Prasad M

Creating Site Collection in Existing Content Database

  
Hi All,

I'm trying to create a site collection in a existing content database. I haven't found a method in Sharepoint object model to perform such a action. There is an option to create a site collection in a new database using the following command:
                                                                
SPSiteCollection.Add(url, siteDescription, siteDescription, 1033, siteTemplate,
                                                                siteCollPrimaryAdmin.LoginName, siteCollPrimaryAdmin.Name, siteCollPrimaryAdmin.Email,
                                                                siteCollSecondaryAdmin.LoginName, siteCollSecondaryAdmin.Name, siteCollSecondaryAdmin.Email,
                                                                strSQLServerName, siteContentDBName, null, null);

Is there a different object to do this creation on existing database? Any ideas to approach this problem will be greatly appreciated

Thanks,

vgurusam


SQL2008 - Cannot Restore a new database from a full backup of a different one, database in use

  
I am trying to restore a brand new database from a copy of another one and am encountering an error message stating: System.Data.SqlClient.SqlError: The file <Backup source database file location> cannot be overwritten.  It is being used by database <Backup Source Database>. (Microsoft.SqlServer.Smo) I am running the Restore procedure with the REPLACE option and am wondering why it is stating that the source database is the database in use when I am trying to restore and overwrite a completely different database. This issue happens when running the replace both in C# using SMO and when manually restoring with SqlServer Management Studio Interesting note is, the original source database is created / deployed using a database project within VisualStudios 2010 and then deployed to SqlServer through VisualStudios. Any thoughts on why this is happening? Thanks in advance for any help!

SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

  
Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

Can't restore database backup file in my database ? using sql server 2005. please help

  
VERY IMPORTANT i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server) i am trying to restore back up database .bak into the new database i just created in sql server 2005 i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message "You must select a restore source" Here's the screen shot:   PLEASE HELP..it's really important (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)  

cross site-collection content query wp

  
Hi,How can i override the Content query wp so i can query data from other site collection? Is it possible?How? Recommended ways? alternatives? references?the site collection is under another site collectioni did some googling and only found a comercial wp for this..tks

Attach site collection data from content databases

  
I have migrated my Sharepoint from a stand-alone installation to a server farm installation by following this article. http://technet.microsoft.com/en-us/library/cc262325%28office.12%29.aspx Every step was completed successfully, except for the last one (4): Install Office SharePoint Server 2007 on a new farm Move databases from the stand-alone server to the server farm Create and attach data from the Shared Services Provider (SSP) Attach site collection data from content databases Whenever I try using the stsadm -o extendvs I get the following message: The IIS Web Site you have selected is in use by SharePoint.  You must select another port or hostname.   The following is the command: STSADM.EXE -o extendvs -url http://dms01 -ownerlogin group\dms -owneremail dms@xxx.com -exclusivelyusentlm -databaseserver jagrb -databasename WSS_Content -apcreatenew -apidname DMS -apidtype configurableid -apidlogin group\dms -apidpwd xxxx   So far, all my efforts to Attach the site collection data from the content databases have failed. Any ideas?

how to restore msdb database on sql 2008 from sql 2005 backup?

  
Currently, I am unable to do it. It gives me the error than I cannot be restored because it was created by a different version of the server. What is the work-around? I hate scripting all my maintenance plans and alerts, there are tonns of themJulieShop

Not able to restore a site collection

  
We have 2 site collections in a farm   URL of site collection 1 is : https://teamsiteqa.portal.keane.com/sites/pdc    URL of Site collection 2 is : https://teamsiteqa.portal.keane.com/sites/pdc-arc   Both pointing to only one content db.   Requirement:   1<sup>st</sup> site collection has huge content and having around 188 sub sites in it. We would like to have entire same data to 2<sup>nd</sup> site collection  for that reason we have 2<sup>nd</sup> site collection is having blank site template   Requirement:   site collection has huge content and having around 188 sub sites in it. We would like to have entire same data to 2<sup>nd</sup> site collection  for that reason we have 2<sup>nd</sup> site collection is having blank site template   In order to meet this requirement we have tried out following steps but no luck. I really thankful to you who can help in this matter.   we have used stsadm restore option but it failed with error GUID ( backup is 1<sup>st</sup> site collection) we have tried to add content db by using stsadm neither this works we have used content deployment option to replicate entire data but this also failed with GUID   Please help us in this matter as this is something urgent.      Ram

"The backup set holds a backup of a database other than existing database. Restore Database is term

  
I have a problem when i restore my .DAT_BAK file.  I am getting error like "The backup set holds a backup of a database other than existing database.  Restore Database is terminating abnormally".   I tried by using   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH MOVE 'VZAI_DATA' TO D:\PROGRAM FILES\..\MSSQL\TEST.MDF', MOVE 'VZAI_LOG' TO D:\PROGRAM FILES\..\MSSQL\TEST.LDF', REPLACE   And also i tried like   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH REPLACE   When i use like this,   RESTORE FILELISTONLY FROM DISK = 'D:\DATA\MYTEST.DAT_BAK'. I am able to get the output as LogicalName, PhysicalName, Type, FileGroupName, Size, etc.   Can i anyone please help me out?   Thanks in Advance, Anand Rajagopal

content Type at site collection level using feature.

  
I m planning to create a feature to install the content type and site colomun at site collection level. Now my doubt is? 1. what will happen when i de activate a feature with documents already there? 2. what will happen when i de activate a feature without documents? What are points i need to take care? 

version dependency while backup restore of SharePoint 2007 Site Collections

  

hi all

I am aware of a version dependency on the stsadm -o backup/restore operation.

But will the same dependency exist for a content DB backup restore..

i.e. for example will we able to restore a content DB backup taken from a server with version say 12.0.0.7777 to a server with say 12.0.0.6666 assuming that the versions of SQL is the same in both cases.

Will the version difference in SQL create issues

Thanks in advance

 

 


pv

Restore Site Collection on a Different Farm with Taxonomy Field

  

Hello,

I am trying to restore a site collection from my production environment into a staging environment (completely separate farm).  However, my site collection contains a Pages library which has a taxonomy field that points to a Managed Metadata Service term store in the production environment.  When the site collection is restored in the staging environment, the items in the Pages library have invalid content in the taxonomy field.  Ie. The values are there, but when I try and edit an item, the values in the picker are invalid. 

I have imported the same term set in the term store in the staging environment but it still doesn't work.  I am assuming it is because all of the terms have different guids in each environment so the values are not 'synching' up properly... 

Can I restore the Managed Metedata Service application from my production environment into my staging environment?  Or, am I going about this process in the wrong way entirely?

Thank you for any advice.

Amy


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend