hi im shailendra singh
my question is how we deploye the data base
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How to disable cut, copy and paste in TextBox using jQuery in asp.net?
Give an example appropriate use forweb service as opposed to a non-serviced .NET component
In what order do the events of an ASPX page execute, As a developer is it important to understand these events?
Suppose there is one web farm with 3 servers inside with same configuration and the same project is running inside all servers.Which session mode is usde for all these and why?
What is the difference between adding reference in solution explorer and adding references by using ?
Mention the namespace that is used to include .net data provider for sql server in .net code?
What are sql joins?
what are the ihttphandler and ihttphandlerfactory interfaces ?
How do you create a master page?
detail code for sql data connections?
Explain the difference between webfarm and webgardens in .net?
what is ienumerable interface?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)