Thursday, October 23, 2008

Chandrayaan to be launched on October 22


India's maiden lunar mission, the Chandrayaan-1 spacecraft that launches on October 22, will orbit about 100 km from the lunar surface for two years, performing remote sensing of the dark side or hidden portion of the moon to unravel its mysteries, scientists working on the project said. About 500 space scientists are working round-the-clock to launch India's maiden lunar mission next week.


The Chandrayaan-1 spacecraft will be launched on board the Polar Satellite Launch Vehicle (PSLV) C11 from the Satish Dhawan Space Centre (SDSC) in Sriharikota, about 90 km from Chennai and off the Bay of Bengal.

"Moon is the nearest celestial body to earth at a distance of 384,000 km. Formation and evolution of moon are central to understanding the solar system. Though there have been many manned and unmanned lunar explorations, Chandrayaan will be the first spacecraft to explore the dark side or hidden portion of moon and unravel the mystery behind," SDSC deputy director M S N Prasad said at a demo of the lunar mission.

According to ISRO director S Satish, the lunar mission is estimated to cost about Rs.3.86 billion ($80 million), including Rs.1 billion for the launch vehicle, Rs.1 billion for the Deep Space Network (DSN) near Bangalore to receive the radio signals transmitted by Chandrayaan and Rs.1.86 billion for the spacecraft, sub-systems and other components, including payloads.



Chandrayaan Antina To Recieve Signals

Wednesday, September 10, 2008

DB BackUp for per day schedule






PERFORMING DB BACKUP OPERATION USING TWO LINES QUERY


1. Create a SP to Back Up entireDatabase
TestingDB is the name of Database for which backup is formed and BackUp.bak is the backup file which will create when u will run query and D:\\ simply Disk Location.
BACKUP Database TestingDB
TO DISK = 'D:\BackUp.bak'
WITH Format

Go
2. Open vs and create a project (Console Application).
write code to call sp in Program.cs for example

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Net.Mail;
namespace CMS_BACKUP
{
class Program
{
static void Main(string[] args)
{
CallBackUpDataBase();
}
private static void CallBackUpDataBase()
{
SqlConnection myConn=null;
try
{
SqlCommand cmd;
myConn = new SqlConnection("Data Source=;Initial Catalog=;User ID=sa;Password= ");
myConn.Open();
cmd = new SqlCommand("Back_Up_CMS", myConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{ }
finally
{
myConn.Close();
}
}
}
}
3. Build project to create exe. exe will create in Debug folder of Solution.
4. Now you can create a window service by using Schedule Task to schedule your exe.