No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ-How will pass the backup copy of a table in a SQL database to a file

Publication Date:  2012-07-25 Views:  51 Downloads:  0
Issue Description

Q:

These are the steps to get a backup file from a table for BMS V200R008 or later on Windows 2003 server system with SQL SERVER 2000 Data base.

Alarm Information

Null

Handling Process

A:

1) choose [program/Microsoft SQL Server/ Enterprise Manager] in “Start” menu.
2)The “SQL Server Enterprise Manager” window pops up and <SQL Server Group>, <local> and  <Database>  are expanded item by item in “Console Root” tree on the left
3)Right click on the data table needing backup to open menu and choose <All Tasks>/<Export Data> to enter “DTS Import/Export wizard” interface.
4)Select the origen data base 
5)In the destination in the menu select "file" then the path of the file
6)Choose query data base and select the specify table.

Root Cause
To get a file from a table in a windows system with SQL Data base
Suggestions

Null

END