Answer / sanjay gupta

You can copy the .mdf and .ldf files and you can attached
the database in the destination server. To do so follow the
following procedure.
1. Stop SQL services in the current server.
2. Copy the two files (viz. .ldf and .mdf) form the source
directory.
3. start the SQL services.
4. Login to the destination server and past the file inside
the data folder of SQL root folder.
5. Start MS SQL Management studio. on the left hand pannel,
right click on the Database folder and click on Attach...
6. Clock on the add button appearing on the attach database
window and select the appropriate .MDF file. Once you
select click on the ok button.

Reach me at sanjaygupta@gmail.com for further information.

Answer / rahul

http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
please refer to this link.

Answer / amit kumar saini

We have to have a SQL script of the database and then we
will create a new database through the script.
Now we have a blank database with same structure and
relationships etc.
Then we can either export/import the data.

Or we can restore the database from a copy of orignal
database backup.

What are user controls and custom controls ?

1 Answers  

---

Whta are the Various steps taken to optimize a web based application (caching, stored procedure etc.) ?

0 Answers  

---

How does session work in asp net?

0 Answers  

---

What is the mvc framework?

0 Answers  

---

Explain the difference between singleton and single call?

0 Answers  

---

What is dynamic web page with example?

0 Answers  

---

What definition correctly defines a label server control with the name set to lblHoop? a) <asp:Label name=?lblHoop? runat=?server? /> b) <Label id=?lblHoop? runat=?server? /> c) <asp:Label id=?lblHoop? runat=?server? /> d) <server label name=?lblHoop? runat=?asp? />

3 Answers   Syntax Softtech,

---

How will u decide when to use caching and when to use viewstate?

5 Answers  

---

Do you know about caching with the datasource controls?

0 Answers  

---

WHAT IS polymorphism

2 Answers   Fidelity,

---

You are using the try? catch block seen in the following code segment, but no exceptions are ever caught by the catch block. What is the problem? SqlConnection cn =new sqlConnection(strSQL); SqlDataSet ds; try { cn.open(); //perform the data processing steps ??.. } catch (OleDbException e) { ?.. } a) The exception class is wrong; it should be sqlErrors. b) The exception class is wrong; it should be sqlSyntaxExceptios. c) The exception class is wrong; it should be sqlExceptions. d) The exception class is wrong; it should be sqlExcptions.

2 Answers   Microsoft, Syntax Softtech,

---

When web.config is called ?

4 Answers   Keane India Ltd,

---