Answer Posted / 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

What is the default fill factor value? : sql server DBA

1129

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1111

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1026

---

Explain materialized views and how they are used.

2443

---

how can you process messages in order asynchronously?

976

---

what is a crs resource?

1166

---

what are the differences of where and if in SAS?

2196

---

What are statistics, under what circumstances they go out of date, how do you update them?

2253

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2232

---

how can you initialize log miner?

1146

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1081

---

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

1077

---

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

2636

---

Where would you look for errors from the database engine?

2852

---

Why does Oracle not permit the use of PCTUSED with indexes?

2944

---