1. Administration Guide
  2. Restoring a Backup File for SQL Server on Windows

Restoring a Backup File for SQL Server on Windows

To restore a backup file for SQL Server on Windows:

  1. Verify that the Select Into/Bulk Copy option on the Options form is turned on for the database into which you will transfer objects.

    Double-click the database in the SQL Enterprise Manager tree structure to access the Options form.

  2. Generate scripts for the tables you want to restore and then drop the tables.

  3. Use SQL to recreate the scripts for the tables.

  4. From the command line, type this command:

    bcp [[database_name.]owner.] table_name(in|out) datafile /n /u /p /s

  5. Perform a SELECT statement to verify that data populates the backup tables.