text: what is difference between export & import in sql server2000? in depth import and export are done for backup purposes as well. you can export your entire database which if i am not wrong creates a dump file. in an event of data corruption etc you can then import the data back to the database from the dump file.  hope this helps