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.

Why do we use asp.net?

0 Answers  

---

Does the following statement executes successfully: Response.Write(?value of i = ? + i);

4 Answers   TCS,

---

How would you enable impersonation in the web.config file?

0 Answers  

---

In a webpage if i want to give access to only half page ,then what should i do?

3 Answers  

---

What is the good practice to implement validations in aspx page?

0 Answers  

---

what is impersonation in ASP.NET?

7 Answers   Accenture, Merrill Lynch, Wipro,

---

What are standard controls?

0 Answers  

---

How is application management and maintenance improved in asp.net 2.0?

0 Answers  

---

Do gac'ed assemblies have fulltrust?

0 Answers  

---

What r new things introduced in ASP.NET 2.0 in comparision to ASP.NET 1.1

1 Answers  

---

how can i am search the data from database? just like google

2 Answers  

---

where can i gather the materials for MCP certification

2 Answers  

---