hi im shailendra singh my question is how we deploye the data base

hi im shailendra singh
my question is how we deploye the data base

Question Posted / shailendra

3 Answers
7155 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hi im shailendra singh my question is how we deploye the data base..

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.

Is This Answer Correct ?

3 Yes

0 No

hi im shailendra singh my question is how we deploye the data base..

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.

Is This Answer Correct ?

0 Yes

0 No

hi im shailendra singh my question is how we deploye the data base..

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.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ASP.NET Interview Questions

What is ispostback method in asp.net?

0 Answers

on modify statement, executeNonQuery returns zero rows affected even though there has been modification carried out sucessfully in the table.. can anyone tell me is this possible??? if yes, how..???

1 Answers ADITI,

What is the caspol.exe tool used for?

0 Answers

what is publisher?

0 Answers Microsoft,

WHT IS DIFFERENCES BETWEEN HTML CONTROLS AND SERVER CONTROLS.

11 Answers HCL, Microsoft,

Which is the best institute in Hyderabad/Secunderabad/Andhra Pradesh to learn DotNet?

0 Answers

Explain the asp.net session state modes.

0 Answers

How many web.config files can I have in an application?