Laughing Man Codex: SharePoint 2013 Single Farm Environment Recovery database content

SharePoint 2013 Single server farm environment recovers database content

Laughing Male Company Service many customers, of course, these customers are very picky, so the general situation of production (PROD) environment services can not stop.

Of course, if you connect a database that contains the same site collection to the same server farm, error! Error! Error! Error! Error! Error! Error! Error!

Error is good, if the entire site application or server farm down, ah ha ~ brother, you immediately is a celebrity!!!!

In a SharePoint 2007 farm, if the customer needs to recover the previous data, the XDJM needs to get the SQL data back to the trial production (PREPROD) environment, using Export/import or backup/ Restore reverts to the production environment in the form of a file.

Fortunately, SharePoint 2013 has a new ability to read files from a non-connected database so that it can be manipulated directly in a production environment, eliminating the transfer of time between data files and databases across different server farms.

Experimental process:

1. Restore the database, this is the work of SQL, but must let XDJM in the same database with the production of the same instance, or can not find, or the use of parameters to locate the database instance name, database name (Laughing Man on the dish for a good while: P);
2. Use PowerShell to find disconnected databases, Get-spcontentdatabase-connectasunattacheddatabase-databasename <DatabaseName>- Databaseserver <DatabaseServer>;
3. Access to Admin Center (Central Administration), using the Restore backup function will be required to the site collection (site Collection), website or list/libraries (library) is divided into files;
4. Use Backup/restore or Export/import in stsadm to import data into a production environment.

Good luck to you guys.

Reference:

Restore content from a content database that is never attached in SharePoint 2013

Laughing Man Codex: SharePoint 2013 Single Farm Environment Recovery database content