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.

How Clustered Index and Non clustered index stored on SQL server?

2 Answers   TCS,

---

What is difference between session and cookies in asp net?

0 Answers  

---

What is cookieless session id explain in brief?

0 Answers  

---

From the given paragraph of text, write a program to match the strings of format “Any number of numerals followed by an underscore followed by any number of alphabets" ex:123_abc (Note:using regular expressions)

4 Answers   Microsoft,

---

What is synchronous and Asynchronous post back ?

0 Answers  

---

---

Can master pages be nested?

0 Answers  

---

when user is logged on the information is saved in a cookie, what is the name of that cookie?

5 Answers   Mind Tree,

---

what is Versioning in asp.net and how it maintain in any web application

1 Answers   TCS,

---

Why select Web API?

0 Answers  

---

What is the answer for "Which configuration Tool your using means" ? we have to tell about IIS or .Net Framework or VSS? Give me in brief ?

3 Answers   eXensys,

---

What are the two properties that are common in every validation control?

4 Answers   Siebel,

---

When working with ASP.Net server controls, it is important to use the right event handlers to capture the event for the application to function properly. What event would you use to capture the selection of a new item in a DropDownList control? a) The Click event. b) The SelectionChanged event. c) The SelectionIndexChanged event. d) The ChangedSelection event.

4 Answers   Syntax Softtech,

---