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 an example of an application service provider?
i have 3+ exp in .net? i am going interview now but they asked me do you know any TOOL? which tool will i study please refer me?
Define application state variable and session state variable?
explain code with multi inhertance
What is the postback property in asp.net?
What is an assembly? Explain its parts.
What is http post and http get?
What is the difference between web.config and machine.config in ASP.NET?
How Can assign alias name for ASP.NET Web API Action?
Why SessionID changes in every request in asp.net?
What is the difference between union and structure?
Just by seeing the signature of the bean how can you specify whether it is a stateful or stateless session bean?
What is the function used for removing an event listener?
Define managed code and managed data in .net?
Explain swagger components.