Post reply

No SQL Server Database Export/Import ?

  • October 23, 2009 at 10:00 am

    #205910

    Hi Folks

    looking at some forums, it is mentioned that there is no database (schema) exports/imports for sql server 2005 as ther would be in oracle.

    So my question is, how does one recover a dropped table, its data and the indexes on that dropped table ?

    is is mainly recovered from the backups ?

    if so, does anyone have any article I can look at or point me in the right direction ?

    Thanks

    Jim

  • October 23, 2009 at 12:01 pm

    #1070204

    Restoring from a backup is probably the most common way to recover a dropped table. Because object level restore isn't available, you would restore and recover the database with a new name, then use BCP or the Import/Export Wizard copy the table back to the original database.

    Some people keep current CREATE scripts of tables and indexes so they can recreate a table then import the data after it's recovered from backup.

    Greg

  • October 23, 2009 at 1:32 pm

    #1070244

    Thanks Very Much Greg

    Jim

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply