Post reply

Import &Export

  • April 27, 2009 at 3:51 am

    #208546

    Hi,

    I need to Import database from webserver .I don't have database backup. we are changing server of our site so we need to export database from old server to new server.

    I have tried using Import/Export wizard but it throws an error message "Failed to copy Objects from Microsoft Sql sever to Microsoft

    sql server".

    i havegone in other way that is i have created New sql group using Enterprize edition but i could not get.

    Tell me any other way.can i import data tables and data using query analyser?

    version:sql server 2000

  • April 27, 2009 at 5:03 am

    #984254

    You can use SSIS to transfer the objects.

    But by far the easiest way is to do a backup/restore or detach/attach of the database.

    Why do you not have any backups?

  • April 27, 2009 at 6:40 am

    #984306

    If you still have the old version of the database online, why not just take a backup of it and then restore it to the new location?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 30, 2009 at 3:26 am

    #986511

    Hi,

    Restore the database to the desired server. Before that take backup of the database for secure purpose.

    Thanks,

    Sandeep

Viewing 4 posts - 1 through 4 (of 4 total)

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