- 1、本文档共15页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
sql server导入、导出、备份数据方法(SQL Server imports, exports, and backup data methods)
sql server导入、导出、备份数据方法(SQL Server imports, exports, and backup data methods)
The number of backup devices used by the 1. media set determines the number of media focused media clusters (the media family)
2. for all restore operations from disk backups, all media clusters must be specified (loaded)
3.RESTORE, LABELONLY, FROM, DISK =E:\backup\, database, \data.BAK
3.1 determine the number of media families in the media set through the result set FamilyCount column
3.2 determines the ordinal number (position) of the media cluster in the media set through the result set FamilySequenceNumber column
SQL Server imports, exports, and backup data methods
Published: admin read: 253 times Keywords: font: [large, medium, small]
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 selected database - complete,
Aim to backup to press Add button
The file name enters a custom backup database file name (the suffix is bak) under the SQL Server server hard disk
Overwrite select overwrite 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 FTP or remote, desktop or PcAnyWhere and other methods
The second step to create the backup database file or its compressed files to the purpose of SQL Server database, if compressed, to decompress.
Four
Purpose SQL Server database, if you do not have this database, first create a new database;
And then select the newly created database, click the right mouse button, select all the tasks, to restore the database
The reduction from the equipment selection of equipment - - Add disk (find backup database file to import name) - determined
Restore the set - database completely
Finally press the OK button. The complete database import succeeded.
If you restore a database on an existing S
您可能关注的文档
- imba(IMBA).doc
- id 32 staph 葡萄球菌的鉴定系统(ID 32 Staph staphylococcal identification system).doc
- iis无法安装(IIS cannot install).doc
- idata_一部别具特色的词典_评_易混同音近音词解析词典_王芳智(Idata_ is a unique _ rating _ dictionary easy mixed words dictionary _ homophone analytic Wang Fangzhi).doc
- internet 的影响(the internet 的影响).doc
- ioc与di(ioc与di).doc
- inter应用 考试大纲_考试大纲_上海市干部培训中心(The application of inter _ syllabus syllabus _ Shanghai cadres training center).doc
- ipad2你不可不知的26个使用小技巧(Ipad2 you must not know the 26 little tricks used).doc
- ipad使用技巧(IPad usage skills).doc
- ipad2和ipad有什么区别和不同(What are the differences and differences between ipad2 and iPad).doc
- 辽师大版八年级上册信息技术 2.2创意南瓜灯--图层样式的使用 教案.docx
- 2024-2025学年中职生自我保护知识普及的教学设计.docx
- 导数的四则运算说课教学设计-2023-2024学年高二下学期数学沪教版(2020)选择性必修第二册.docx
- 2024-2025学年告别侥幸心理的安全教学设计.docx
- 2024-2025学年利用案例分析进行霸凌预防教学设计.docx
- Unit 4 Fun with numbers Fuel up(教学设计+素材)-2024-2025学年外研版(三起)(2024)英语三年级上册.docx
- 9.1《念奴娇赤壁怀古》任务式教学设计统编版高中语文必修上册.docx
- 第14课 我的播放器——音频播放器和滑动条的使用 教案 教案.docx
- 3.6电能教学设计---2023-2024学年浙教版科学九年级上册.docx
- Lesson 3 A computer has a keyboard(教学设计)-2024-2025学年科普版英语五年级上册.docx
文档评论(0)