当前位置: 代码迷 >> Sql Server >> 为什么无法指定介质名称?该怎么解决
  详细解决方案

为什么无法指定介质名称?该怎么解决

热度:73   发布时间:2016-04-27 19:19:17.0
为什么无法指定介质名称?
backup LOG [ilovemk] to 
DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ilovemk_log_01.bak',
DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ilovemk_log_02.bak',
MEDIANAME = 'ilovemkStripedSet0'

报错:'MEDIANAME' 不是可以识别的 Device Type 选项。

------解决方案--------------------
SQL code
backup LOG [ilovemk] to  DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ilovemk_log_01.bak',DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ilovemk_log_02.bak'withMEDIANAME = 'ilovemkStripedSet0'
------解决方案--------------------
SQL code
backup LOG [ilovemk] to  DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ilovemk_log_01.bak',DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ilovemk_log_02.bak'withMEDIANAME = 'ilovemkStripedSet0'
  相关解决方案