.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Need to make a copies of an sql database

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :ASP.Net
 I am developing applications that use Microsoft sql server databases.  I use SQL Server Management Studio to create these databases and add table, etc.  I would like to be able to make a duplicate copy of one of these databases so that I could use one database for production and the other database for testing.  Is there some way to do this?  Also is there some way that I can copy a table in one database to another database? Thanks, Bette  

View Complete Post

More Related Resource Links

Unable to make connection to database?


Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.

I have database called PhoneDirectory.

It have only one table named Residents.

I have button wiht ID="Button1".

I want when i click this button to see all of my residents. 

I want to see the result in DetailsView and to be able to edin, delete and add new resident.

First try with SqlDataSource so i wrote this:

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>" 
              SelectCommand = "SELECT * FROM Resident "

how to make a back up file(.bak) of database


I need to make a back up file(.bak) from my database (.mdf)

I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't. What am I doing wrong.. Please help.

How to make a backup file (.bak) from a database (.mdf)


I need to make a backup file(.bak) of a database(.mdf)

I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.

I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong? Pls see the screet shot. Please help!

help: user "sa" cannot make DDL changes after I turned on DDL auditing via database trigger


I created a database trigger to track DDL changes to SQL 2008 database:



I have already created the AuditDB database and DDLAudit table:

   CREATE TABLE dbo.DDLAudit ...


How to make Windows SharePoint Services use a preexisting database as the content database

From the link below. I am trying to find in Central Administration the following:

  • Replace each instance of AdminVsAppPoolIdentity in the query with the account that is the SharePoint Central Administration virtual server application pool identity. This account is also the database owner (dbo) of the database.
  • Replace each instance of ContentVsAppPoolIdentity in the query with the account that is the content virtual server application pool identity.

  • http://support.microsoft.com/default.aspx/kb/888041

    Where do I find the AdminVsAppPoolIdentity and ContentVsAppPoolIdentity ??

    Unable to connect to database. Check database connection information and make sure the database ser



    I am using MOSS2007. My MOSS site was working fine for last 1 month and today suddenly it started to show me below message

    "Unable to connect to database.  Check database connection information and make sure the database server is running."


    On my server, SahrePoint admin site is working. Other port site is also working. Only my MOSS site is showing me above message.  Can anyone helkp me to resolve this issue.

    Database Table E-R Entity Relationship Layout - please make suggestions and/or improvements ?


    Not quite sure where to post this, but need some help defining a schema and E-R modelling, I'm not sure if I'm maybe making it too complex... 15 Tables in total right now




    I have a store which Buys, Sells and Repairs - Laptops and Mobiles and Video Game Consoles and Printers.

    This is a walk-in store, so customers can pay cash (and not have their details recorded) or they can pay by card. 


    When buying therefore, if ordering via the Internet, customers will have their details recorded and added to the database, but if buying in the store, customers are unlikely to have their details recorded when buying unless they are making a return.

    Customers will always have their details recorded when arranging a Repair.


    I think I may need separate Orders and Sales tables, because Sales may be connected through an EPOS system, but Orders refers to internet orders, I'm not quite sure about this just now.


    All items marked with * denote foreign keys.

    So far I have the following table layouts, I'm sure I have missed something:




    How to make a Bangla language based database and software ?


    I want to create a software using C#.NET which is a Spell Checker for Bangla Language. For this, I need to build a database which will store the 'Bangla' words and by programming, it will check the spelling.
    I also asked the same question in Codeproject.com .Anyone replied me "Make sure your database is Unicode capable and aware".So which which are Unicode Capable database.Is SQL Server?

    So how can I do it?

    Multiple database support with Entity Framework

    One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

    This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

    Export Visio Database Table Names to Excel

    If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

    MS SQL Server: Disconnect Users From Database - Kill User Session

    If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

    Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

    We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

    Below is the complete step by step guide of this process.

    Adding Rows in GridView without using a Database

    This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

    Adding Multiple Columns and Rows in GridView without using a Database

    This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

    ASP.NET Database Tutorial

    This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

    The GridView control is a powerful tool and is simple to implement.

    First, you will need to import the System.Data.SqlClient namespace.

    Connestion string create any database server

    This links important to how to create connection string to any data base sever.

    SQL Server Database Transaction

    A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

    Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:
    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend