Answer / pandians

Moving Data :
-------------
1. Configuring Linked Server between servers and move the
data using four part naming convension
i.e: Server.Database.Schema.Table
2. Use Export and Import wizard
3. Using SSIS or DTS Package to move data to different
database or server
4. Use three part naming convension to move data to
different database within the server/instance.
5. Using BCP to move data.

Moving Database:
----------------
1. Detach...Attach
2. Backup and Restore
3. Stop the Service
3.1 Using Alter statement to relocate the database path
3.2 Copy the files into new location
3.3 Start the Service
4. But, Moving system database except Master and Resource
can follow the above way

Answer / santo

export/import...attach/detach...DTS....backup/restore!

Answer / monal

BCP (BULK COPY PROGRAM)

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

---

Oracle 11g new features?

2 Answers  

---

Explain the use of table functions.

1 Answers  

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

what is the use of home directory???

1 Answers   HP,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---