2018年

SQL Server卸载清理

SQL Server卸载清理步骤正常卸载,卸不掉的用Uninstall Tool强制删除用Windows Install Clean Up删除剩余的项目删除注册表HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft ODBC Driver 13 for SQL Server HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\...
阅读全文

SQL Server备份和恢复

备份完整备份backup database [db1] to disk = N'E:\Backup\db1.bak' with init;差异备份backup database [db1] to disk=N'E:\Backup\db1_diff.bak' with init,differential;备份文件按日期命名新建存储过程Backup_db1,备份数据库db1USE [db1] ...
阅读全文