Managed Data Hosting::RestoreCustomerDbFromDisk

This procedure performs a full restore of a specified database from disk. Simple pass-through method to the SQL Admin Provider with an additional security check.

Note

You cannot immediately restore a database from backup over an existing database. Wait at least five minutes before attempting the restore procedure.

Arguments

Remarks

Method

public string   RestoreCustomerDbFromDisk(
										string orgLdapPath, 
										string databaseName, 
										string preferredDomainController,
										string filePath, 
										string serverName, 
										string dataRootShare,
										string position, 
										string sqlUserName, 
										string sqlUserPass,
										bool sendCredentials)

Sample Code

Typical C# Usage

//Get user name and password.   
		string userName = this.Request.ServerVariables.Get("AUTH_USER");
		string pass = this.Request.ServerVariables.Get("AUTH_PASSWORD");
		//Set credentials.
		sqlAdminWS.PreAuthenticate = true;
		sqlAdminWS.Credentials = new NetworkCredential(userName,pass);

		lblMsg.InnerHtml = mpsResponseHeaderLabel;
		//Display response.
		this.mpsResponse.DocumentSource = "";
		response = sqlAdminWS. RestoreCustomerDbFromDisk(orgLdapPath,databaseName, 
preferredDomainController,filePath, position, sqlUserName, sqlUserPass, sendCredentials);
					
		// set the response XML to match the return from MPF
		responseXml.LoadXml(response);
		this.mpsResponse.Document = responseXml;
lblDone.InnerText = successMsg;

Applies To