Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server 2000 Interview Questions > Getting a database dump

:: Categories ::

Interview Question in SQL Server 2000


 

Interview Question :: Getting a database dump


can somebody explain to me how to get a database dump from a database server (MS SQL 2000 server). Primarily i wanna get an existing database file from this server and put it down in my workstation. clear instruction please
Answers to "Getting a database dump"
RE: Getting a database dump?

just copy the database files
 
Vote for this answer ::  
RE: Getting a database dump?

Use detach existing database (right click on database name in EM),

copy .mdf and .ldf files,

paste them on your workstation and

use attach command (right click in EM)
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License