Servers and Databases in SQL Server

Hi,

Please refer this microsoft tutorial for detailed description.

http://support.microsoft.com/kb/314546

Hi Arun,



There are several ways of doing this. One can use any of the following options:

- BACKUP/RESTORE,
- Dettaching/attaching databases,
- Replication,
- DTS,
- BCP,
- logshipping,
- INSERT...SELECT,
- SELECT...INTO,
- creating INSERT scripts to generate data.


Thanks