mssql数据库导出和导入（MSSQL database export and import）.docVIP

mssql数据库导出和导入（MSSQL database export and import） MSSQL database export and import Export a database into SQL Server 1. in SQL Server enterprise manager to select the transfer database, click the right mouse button, select all tasks - backup database. 2. backup database completely and press the Add button to backup to the backup database file name file input and a custom SQL Server server hard disk under the name (suffix is bak) rewriting selected to rewrite existing media finally press the OK button. If the generated backup database file is larger than 1M, it is compressed using the compression tool and then transmitted to the Internet. 3., through the FTP or remote, desktop or PcAnyWhere and other methods, the second step of the backup database file or its compressed files to the purpose of SQL Server database, if compressed, to decompress. 4. SQL Server database if not this database, you create a new database; and then select the newly created database, click the right mouse button, select all the tasks, to restore the database restore - select equipment - - - Add disk from the device (find copies of the database file to import name) - determined to restore set - Database - completely finally press the OK button. The complete database import succeeded. (if the existing SQL Server database restore database may have other people are using it and the recovery operation failed, can go to the currently active management - - find / object lock process - lock database to query analyzer with kill process, kill the lock, and then make a reduction) Be careful： If the purpose of the original SQL Server database from the backup file to restore the database (*.bak) will put the existing tables, stored procedures of database: like all replaced the latest imported backup database content. If you want to restore the backup file (*.bak) in the part of the data, also need to build a new database, the logical name and number with the backup file (*.bak) in the same logica