SQL Server Performance

Logical Backup using Export/Import

Discussion in 'SQL Server 2005 General DBA Questions' started by y.koteswarrao, Mar 2, 2010.

  1. y.koteswarrao New Member

    Hi,this question is asked by an interviewer,how to take the logical backup using export/import... is it possible or feature available in sqlserver if so...please let me know...
    Thanks
    Koteswar Rao
    y.koteswarrao, Mar 2, 2010
    #2

  2. FrankKalis Moderator

    I would guess that interviewer is on about logical devices that you can define yourself and which point to a physical backup device. Just search for "logical devices" in the Books Online. It's all there. [:)]
    FrankKalis, Mar 3, 2010
    #3

  3. lancyqusa New Member

    There is a feature available through the SQL Server Management Studio to export and import data on a per table basis. I wouldn't necessarily use that as a backup mechanism unless it is just a few tables. Data exported/imported in this manner is done by means of an SSIS package that Management Studio creates and executes behind the scenes. Since it is an SSIS package, you have the option of using a variety of data formats you could use to export/import data - flat file, excel, another database etc.
    This feature is very different from the ORACLE export/import which could be used for backups since you could export out the entire database using a single command and import parts of it if need be.
    Hope this is helpful!
    Lancy
    lancyqusa, Mar 4, 2010
    #4

Share This Page