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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what the contents of cookie?

778


What is custom events? How to create it?

803


Explain Areas in MVC?

816


What is difference between session and application in asp net?

717


What is syntax code to send email from an asp.net application?

736


How do we implement bundling in MVC?

816


Which method do you use to enforce garbage collection in .net?

703


Explain security types in asp.net?

756


How do you identify that the page is postback?

707


What is directive in asp net?

733


What are the differences between application object and session object?

719


What is the difference between executescalar and executenonquery?

707


How asynchronous call can be implemented using delegates?

755


What is the purpose of asp.net?

718


What are the advantages of asp.net?

720