Forum Discussion

meghaphophalia's avatar
meghaphophalia
Occasional Contributor
3 years ago

Java script Code for restore database

I write this script for restore database. But getting the error -Login failed for user 'fastreact' . function To_Restore_DB_FR4() { if(Aliases.FR4.Exists) { Aliases.FR4.Terminate() } var query...
Debugging
Desktop Testing
Script Tests
Test Run
VirginiaSus3's avatar
VirginiaSus3
Occasional Contributor
bak' which is available in 'D:\' location if you are overwriting the existed database. If you are creating a new database with this restore command and there is no similar path of data, log files in target server, then use move option like the following command.
it('should return validation error if metric type is invalid', async () => {  sinon.stub(Metric.prototype, 'insertDatapoints').returns([])  sinon.stub(MetricsStoreProxy.prototype, 'get').returns(new Metric({metricID: '1', type: 'Mock'}))  sinon.stub(MockService.prototype, 'shouldAdminPostDatapoints').returns(false)
  const id = 123
  await handle({[id]: []}, null, (error, result) => {   error = JSON.parse(error)   assert(error.length === 1)   assert(error[0].message.match(/Mock/))  })
  MockService.prototype.shouldAdminPostDatapoints.restore() })

 

rraghvani's avatar
rraghvani
Champion Level 3
3 years ago

Are you able to query a table, for example.

function test()
{
	var conn = ADO.CreateConnection();
	conn.ConnectionString = ""; // Use correct database connection string, https://www.connectionstrings.com/microsoft-ole-db-provider-for-sql-server-sqloledb/
	conn.Open();
	// If the query fails, then database connection string is incorrect
	conn.Execute("SELECT * FROM table_name;");
	conn.Close();
}

 This is just to test that the database connection string is correct