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

2012-01-19

为什么无法指定介质名称？backup LOG [ilovemk] toDISK ND:\Program Files\Microsoft SQL Server\MSSQL1

为什么无法指定介质名称？
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 codebackup 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'