Home >Database >Mysql Tutorial >设置密码保护的SqlServer数据库备份文件与恢复文件的方法
设置密码保护的SqlServer数据库备份文件与恢复文件的方法
- WBOYOriginal
- 2016-06-07 18:03:521077browse
设置密码保护的SqlServer数据库备份文件与恢复文件的方法，需要的朋友可以参考下。
设置密码保护SqlServer数据库备份文件！备份SqlServer数据库
Backup Database [数据库] To disk='c:\mysql'+ replace(replace(replace(replace(CONVERT(varchar, getdate(), 121),'-',''),' ',''),':',''),'.','') +'.bak' With Password = '123',init;
恢复SqlServer数据库
Restore Database [数据库] From disk=数据库备份文件地址 With Password = '123';
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql中判断记录是否存在方法比较Next article：mysql千万级数据大表该如何优化?