none
sql server 2016执行备份计划失败 RRS feed

答案

  • 你好,

    根据你的错误提示,应该是’SQLPS’不在默认模块目录中而无法加载,你可以尝试以下步骤手动更新SQLPS模块的路径来解决此问题:

    1. 首先查看一下SQLPS是否存在该目录: C:\Program Files(x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\SQLPS
    2. 运行以下命令:$env:PSModulePath = $env:PSModulePath + ";C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules"
    3. 运行以下命令检查SQLPS是否再可用模块中:get-module listavailable
    4. 然后重新执行备份计划

    希望能解决你的问题,如果还有任何问题,请随时告知我

     

    Best Regards!

    Dawn Yang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月24日 9:36
  • 是在Powershell上面执行上面两个命令

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:01
  • 在POWERSHELL运行如下

    返回的结果如下:


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:47
  • 这是在哪里执行的?数据库上还是windows命令?
    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:53
  • windows左下角搜索' powershell'

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:57
  • 另外想问一下你们的操作系统是Linux吗?一般Powershell用于Linux的。

    如果你是要制定一个备份计划,可以在SSMS里用维护计划向导制定备份计划,相对比较简单,你可以参考下文的步骤进行配置:

    https://www.cnblogs.com/1312mn/p/10156897.html

    切记,先对现在的数据库进行备份,然后到测试环境下测试备份计划,如果满足需求再在生产环境制定备份计划


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 2:01
  • 你可以尝试用维护计划向导重新做一个备份计划,刚刚发给你的链接有步骤

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 2:18
  • 你先别删除,你到测试环境下创建个新的备份计划,如果测试没问题,再替换到生产环境

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 2:35
  • 针对你一开始的SQLPS模块无法启用的问题的解决方案,如果觉得有用的话,帮忙'Mark As Answer'一下,谢谢了

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:37
    2019年12月25日 6:30

全部回复

  • 你好,

    根据你的错误提示,应该是’SQLPS’不在默认模块目录中而无法加载,你可以尝试以下步骤手动更新SQLPS模块的路径来解决此问题:

    1. 首先查看一下SQLPS是否存在该目录: C:\Program Files(x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\SQLPS
    2. 运行以下命令:$env:PSModulePath = $env:PSModulePath + ";C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules"
    3. 运行以下命令检查SQLPS是否再可用模块中:get-module listavailable
    4. 然后重新执行备份计划

    希望能解决你的问题,如果还有任何问题,请随时告知我

     

    Best Regards!

    Dawn Yang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月24日 9:36
  • 是在数据库上执行吗。这样操作对吗
    2019年12月25日 0:39
  • 我查看备份历史记录,发现今天凌晨0点开始执行备份,0.32执行完,成功了。可是凌晨2点又开始执行备份计划了,还是报那个错误。为什么2点又要自动执行备份计划报错呢。备份盘里也看到了12月25日的bak文件了。历史记录里还是看到报错
    2019年12月25日 0:43
  • 是在Powershell上面执行上面两个命令

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:01
  • 如果可以的话,能把你的备份计划贴给我看看吗


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 1:04
  • 不好意思,我不会方法。臣妾做不到啊,能贴图指教一下吗
    2019年12月25日 1:30

    • 已编辑 weqterewq 2019年12月25日 1:36 这个4天是我临时修改的,因为空间不足
    2019年12月25日 1:34
  • 在POWERSHELL运行如下

    返回的结果如下:


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:47
  • 这是在哪里执行的?数据库上还是windows命令?
    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:53
  • windows左下角搜索' powershell'

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 1:57
  • 另外想问一下你们的操作系统是Linux吗?一般Powershell用于Linux的。

    如果你是要制定一个备份计划,可以在SSMS里用维护计划向导制定备份计划,相对比较简单,你可以参考下文的步骤进行配置:

    https://www.cnblogs.com/1312mn/p/10156897.html

    切记,先对现在的数据库进行备份,然后到测试环境下测试备份计划,如果满足需求再在生产环境制定备份计划


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 2:01
  • 操作系统是windows
    2019年12月25日 2:06
  • 你语句怎么都复制了两遍

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 2:16
  • 你可以尝试用维护计划向导重新做一个备份计划,刚刚发给你的链接有步骤

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 2:18
  • 不是执行两个语句嘛?这两个命令不一样。我贴图的是两个命令吧 
    1. 运行以下命令:$env:PSModulePath = $env:PSModulePath + ";C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules"
    2. 运行以下命令检查SQLPS是否再可用模块中:get-module listavailable
    2019年12月25日 2:31
  • 我原来的计划删除?重新做一个计划?可能是我原来的计划有问题?
    2019年12月25日 2:32
  • 你先别删除,你到测试环境下创建个新的备份计划,如果测试没问题,再替换到生产环境

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:38
    2019年12月25日 2:35
  • 你的语句写了两遍

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 2:36
  • 你的语句写了两遍


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 2:37


    • 已编辑 weqterewq 2019年12月25日 5:43 这个需要升级数据库解决吗?
    2019年12月25日 5:32
  • 报错显示你的评估期过了,你使用的是SQL Server 2016什么版本?

    如果是非生产环境的话,建议你安装开发者版本


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 5:48
  • 你用的企业版,评估期到了,应该需要买新的密钥了,我看你之前的贴子也是这个问题

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 6:11
  • 另外想问一下,你用Powershell运行了那两个命令了吗? SQLPS在可用性组里面了吗?



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 6:17
  • 需要升级,输入新的密钥吗?这个是百度搜索 的密钥,可以吗
    2019年12月25日 6:18
  • 你可以尝试一下,作为工作人员不推荐

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 6:19
  • 多谢了,麻烦您了,辛苦了
    2019年12月25日 6:25
  • 我原来的序列号是买的啊,怎么能过期呢
    2019年12月25日 6:28
  • 针对你一开始的SQLPS模块无法启用的问题的解决方案,如果觉得有用的话,帮忙'Mark As Answer'一下,谢谢了

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • 已标记为答案 weqterewq 2019年12月25日 6:37
    2019年12月25日 6:30
  • 你之前买序列号的使用期已经过了

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 6:43
  • 确保'SQLPS‘模块能正常启动以后,你再重新尝试一下你一开始用powershell语句的备份计划吧

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月25日 6:50


    • 已编辑 weqterewq 2019年12月27日 14:00 看出来这个报错的不是备份计划,而是作业历史记录报错,为什么会这样?
    2019年12月27日 10:01
  • 这是我执行那两命令返回的结果
    2019年12月27日 10:21
  • 这说明你的'SQLPS‘模块可以用了,你现在的报错信息是什么?


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2019年12月30日 9:28