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
What is semantic gap?
What is asp.net globalization?
What are merge modules?
What is advantage of code behind coding in ASP.NET?
Explain the benefits of viewstate?
What is parse in asp.net?
What is difference between asp.net and asp?
Explain the use of fragment caching.
Can we use a static function with a non-static variable?
What is a web farm?
What is a master page and what does it do?
If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?
Write the different features of a Thread and a Process?
What is base class of button control in .net?
Suppose You Want A Certain Asp.net Function Executed On Mouseover For A Certain Button. Where Do You Add An Event Handler?